Power Query Issue

[kelyndm]

I am having an issue in power query. My coworker with the exact same computer/setup/ and visibly same excel settings, working in Excel 2016 stand alone does not have the same issue, and is able to refresh the queries that I create by I am not. The issue is: Every time that I try and create a power query, from a table within the workbook I am working in, Excel gives me the following error when I try to "Close and Load" or refresh the query:
"Initialization of the data source failed. Check the database server or cantact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database."
Immediately following this error, I also get the error:
"The following data range failed to refresh: ExternalData_1 Continue to refresh all?"

I cannot for the life of me figure out why I am getting this error. Like I said, the query data source is an internal table. I have found out that "ExternalData_1" is a named range that is hidden, and I presume that Power Query is creating it. The ExternalData_1 refers to the same range that my Table I am running the query off of is in.

Any idea of why this might be occurring? Thanks!

 

[anvg]

Hi
I had an equal issue with my Excel 2016 64bit. I solved it by setuping Power BI Desktop 64bit. Maybe it helps you too.
Regards,

 

[kelyndm]

Thank you anvg, I will try this out tomorrow morning when I get to work and report back.