Intermittent Problems using Azure Analysis Services Model in PowerBI

[alankay]

Hello,

I have created a tabular model of data using the Azure Analysis Services SAAS feature (B1 tier, ~5Gb in size).

I can connect to my model using PowerBI Desktop, and it works great... for about five minutes.

After a while I start to find that some of the visualisations stop refreshing (Showing the "Can't display the visual"/"No OLE Database Found" error message - but clicking the Refesh button sometimes fixes it, only for a different visualisation to then fail. If I have four visualisations in a report, it is almost impossible to get them to refresh at the same time (see picture).

After a bit longer, I usually get a message saying "Couldn't Load the Model Schema", and nothing works anymore. The only thing to do then is save the .pbix file, restart PBI Desktop and start again... but I only get a few minutes (if I'm lucky) before the whole thing starts again.

It feels like the Azure AS service is "timing out" after a period of time -but I can't find any documentation of this being a feature you can change.

I have tried different internet connections, and laptops, so I have ruled out a problem with network.

Has anyone experienced any similar problems?

[Anonymous]

@alankay,

When you use SQL Server Management Studio(SSMS) to connect to Azure Analysis Services, do you get any issues when selecting data from tabular model?

If everything works in SSMS, please use the latest version of Power BI Desktop(2.48.4792.481) and use both modes("Import" and "Connect Live") to connect to Azure Analysis Services, then check if the issue still occurs.


Regards,
Lydia