Showing results for 
Search instead for 
Did you mean: 
alankay Visitor

Intermittent Problems using Azure Analysis Services Model in PowerBI



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?



Moderator v-yuezhe-msft

Re: Intermittent Problems using Azure Analysis Services Model in PowerBI


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.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)