Azure Database - Cannot load model (unstable)

carloemilio · ‎09-14-2022

Hello there.

We have an Azure database, and we build a report on Pbi from that.

We published it according to the tutorials we read.

The local IP from our machine its authorized in the Azure database setup
The dataset is right connected to the database

But, when we try to open the report, the following message is displayed:

"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 try again later or contact support. If you contact support, please provide these details."
Detalis:
Activity ID: 468fd335-1498-48f3-bb82-030a4e1880a8
Request ID: ec7f1b5b-9bba-3d44-9381-623bdff00734
Correlation ID: b1df7733-c912-a677-0672-aab2a10d4ad8
Time: Wed Sep 14 2022 13:49:54 GMT-0300 (Horário Padrão de Brasília)
Service version: 13.0.19040.38
Client version: 2209.1.13144-train
Cluster URI: https://wabi-brazil-south-redirect.analysis.windows.net/

It sounds like a normal connectivity issue, but the problem is that sometimes, we can see the report correctly.
Sometimes we can access the report, sometimes we don't.

For example, at this moment we recieved the "Cannot load model" message, but a few hours ago it was working fine.

Yesterday, it was not working in the begginig of the day, and it start to work randomly in the middle of the afternoon.

Can someone help us to understand our issue here?

Tks a lot

Anonymous · ‎09-16-2022

Hi @carloemilio ,

Here's some requirements you might check:

1. Make sure the reports you are creating in PBI desktop are pointing to the right server and cube

2. Make sure the datasources in your Enterprise gateway points to the right server and cube.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.