Hi all,
I've used Power Query to build a workbook that contains queries pulling in from two external databases - MySQL and Teradata, and then using Power Query I do some manipulation for the final output. I'm trying to understand why when I shared this workbook (sent via e-mail as an .xls) the recipient can open, but not refresh the data. She gets the error "Initialization of the Data Source Failed".
Questions are: 1) Do I need to forward each .odc file created by Power Query? and 2) where do other users get the opportunity to input their credentials to query against the databases (these are unique to each user)?
Thanks for any insight / suggestions.
Crystal
I've used Power Query to build a workbook that contains queries pulling in from two external databases - MySQL and Teradata, and then using Power Query I do some manipulation for the final output. I'm trying to understand why when I shared this workbook (sent via e-mail as an .xls) the recipient can open, but not refresh the data. She gets the error "Initialization of the Data Source Failed".
Questions are: 1) Do I need to forward each .odc file created by Power Query? and 2) where do other users get the opportunity to input their credentials to query against the databases (these are unique to each user)?
Thanks for any insight / suggestions.
Crystal