Unable to Connect to import or direct query reports

Question

Opened BI this morning and am getting "Unable to Connect" error with not further details. Pretty much useless.

The gateway is still up and running and data is refreshing online which is great.

I have tried reinstalling BI desktop, signing out, signing in with different users, attempting to create new import and direct query reports all no good.

When opening a direct query file that I have previously created I get

I can get through to the report but unable to refresh the data or acutally do any modelling.

When trying to refresh a Power BI Direct Query file I get the below error.

Answer 1

Check your cached data sources. Once in a while, it seems like these can go bad, or a change somewhere to password or configuration impacted them.

You can edit or remove your cached data sources by going to File - Options and Settings - Data Source Settings - click on "Global Permissions" highlight the data sources that are affected and either update them or delete them and reconnect. This should resolve any connection error as long as all the permissions are there.