cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alankay
Regular Visitor

Intermittent Problems using Azure Analysis Services Model in PowerBI

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?

 

Capture.PNG

1 REPLY 1
v-yuezhe-msft
Microsoft
Microsoft

@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

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

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors