Error when Refreshing SQL Data

Hi all!

I had exactly the same problem, yet the solution turned out to be the silliest one.

For each data source, check the name of the server and the database, it seems to be case sensitive when deployed to the server, but not when using the Power BI Desktop.

So, if you have two or more data sources to the same DB, but one is defined as server1;myDB and the other one as server1;mydb (or Server1;myDB versus server1;myDB, or any other permutation), it will certainly fail.

Use the exact connection string already stored in the Power BI Server for the faulty dashboard, modify your data sources with Power BI Desktop, redeploy and retest the refresh, it worked for me.

Hope it helps!

Cheers,

LB.