Connection status shows "Unable to connect" for all data sources in workspace

[S4CSurrey]

While my datasets are refreshing and completing, the linked sources (Analysis Services and/or SQL Server) have a connection status of "Unable to connect".

The workspace was created by someone else, and checking the detailed connection settings would require me to take over the settings (cannot do this right now).

Does anyone know what exactly a workspace data source displaying "Unable to connect" means entirely? Azure resources show these linked Analysis Services and SQL servers as online.

If I look at my reports, the last date for data is June 1st - this is what lead me to check the path of the report and see if there are any issues.

Any assistance is appreciated.

[nickyvv]

Hi @S4CSurrey,

You say the linked sources have a status of unable to connect. Where do you see that message?
And are you using an SSAS Live connection in the report? Do you have access rights to that SSAS server/database? Can you connect with SSMS for example?

[S4CSurrey]

Please see this screenshot:

[nickyvv]

Thanks for the update.
Do you have access rights to that SSAS server/database? Can you connect with SSMS to the SSAS-instance for example?

[S4CSurrey]

In Azure I can connect and see the models of AS, and with SQL Management Studio I can connect up and see data as of today. There might be a disconnect somewhere between what SQL has, and what AS is loading.

In SQL Management Studio, I have also been able to connect to the Analysis Service, and the schema is showing up in there as well.

[v-deddai1-msft]

Hi @S4CSurrey ,

Since I can't reproduce your issue. I would recommend you open a support ticket on the support.powerbi.com site.

Best Regards,

Dedmon Dai