Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
hawb
Helper I
Helper I

Cannot load model while connecting to Azure Sql Database (works fine on powerbi desktop)

Hi,

I've more than one dashboard connecting to an instance of Azure Sql Database using DirectQuey and they were perfectly working until this morning when I started getting this error:

Cannot load model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please check the technical details for more information. If you contact support, please provide these details.
Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 503. PowerBIErrorCode: OpenConnectionError
OpenConnectionError: Failed to open the MSOLAP connection.
Correlation ID: 7f4e26d3-0a37-1fe1-4a11-3ef8a8b97b12
Activity ID: ed23bcd7-577c-4c97-9c7c-a62c75eeb10a
Request ID: 89876869-1cbe-e03d-be34-45fda508b1b7
Time: Mon May 18 2020 15:38:29 GMT+0200 (Ora legale dell’Europa centrale)
Service version: 13.0.13248.257
Client version: 2005.1.00976-train
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/

This happens on both Powerbi app and on our custom web application that uses Powerbi embedded. The dashboard works nicely on PowerBI desktop; I've also tried to create a fresh new dashboard for test connecting to the same Azure Sql DB without luck (same error).

 

Looking at the error I'm a bit confused as it refers to a MSOLAP connection while we're actually connecting to a standard SqlServer in Azure using the basic connection (user/pwd) without OAuth2 setting.

 

Lastly, if I try to refresh the dataset in Powerbi app from the settings page it works without issues.

 

Any hint would be much appreciated,

Thanks

Mike

1 REPLY 1
v-gizhi-msft
Community Support
Community Support

Hi,

 

Hope this can help:

https://community.powerbi.com/t5/Service/Cannot-Load-model/td-p/891780 

 

Best Regards,

Giotto

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.