We couldn't refresh multiple tables, including XXX form connection "Query - XXX".

[Anonymous]

Hi! 

Every single month I upload some files into folder and then I want to update PowerQuery and PowerBI report, during this month, I have the problem like on the snip below at the moment when I want to refresh the file. I just want to confirm that all of the connections are ok. Could you please give me a tip how should I resolve this problem?

[Anonymous]

Hi @Anonymous ，

What data source are you using, Excel or other data source? Is the data coming from multiple data sources? Do the tables circled in red in the screenshot below exist in your data source? Is Query -  Data_BOP the server name? When did you perform the operation to get the error message?

Best Regards

[Anonymous]

As it comes to data source which I'm using, it's Misrosoft Excel. And yes - the data comes from multiple sources. 

Do the tables circled in red in the screenshot below exist in your data source - yes, they exist. 

When did you perform the operation to get the error message? - when I uload new files: FxRates, Data BOP, Actuals into particular folder, then I wanted to refresh my major file and after that I got this error. 

Is Query -  Data_BOP the server name?  - what does it mean?

[Anonymous]

what does ODBC client mean?

[lbendlin]

Whatever you want it to mean - could be Excel, or even just the Test button on the ODBC control panel. Your preferred client.

[lbendlin]

Can you login to the database with the same credentials from a different ODBC client?