cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors