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

Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

I have a database (AzureSQL) which is deployed in Azure in Brazil South region.

During my analysis in PowerBI Desktop, the data are OK and I'm able to connect and run some visual on that. 

When I try to publish, at the beginning no errors were presented. But, once I access the report, I got a generic error:

 

The model cannot be loaded The model schema associated with this report cannot be loaded. Make sure you have a connection to the server and try again. Try again later or contact support. If you contact support, please provide these details.

 

ID da atividade: 39e5a61b-f36a-4d77-bc84-f1850bb0ef49
Solicitar ID: 96ad1f19-958e-456d-ce6f-fecc0b272d09
ID de correlação: 111ee565-c9f4-f85d-3291-9093a6399ca0
Hora: Mon Jul 13 2020 10:47:27 GMT-0300 (Horário Padrão de Brasília)
Versão do serviço: 13.0.13860.51
Versão do Cliente: 2007.1.01830-train
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/

 

Actions I did:

 

Deleted the report.

Recreated.

Created a new version of report with only a visual.

Cleared the permissions in datasource.

Change the permissions (None, Public and Organization)

 

All actions failed.

In Azure it is permitted to that server use Azure Services.

 

In the PowerBI Dataset, the connection is OK. I don't need Gateway because I use the AzureSQL.

 

Any clues?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

Despite the user and password were correct, the option of OAuth2 was checked, and instead to use the database credential, I think the service tried only to use the OAuth2.

 

After unchecking that option it worked!

 

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

Hi , @michelpf 

Do you have other data source in your report or apply any RLS in your datasource?

It is recommended  to update your credentials  again  on power bi service  dataset side first.

 

The following tips also need attention  .

1.Make sure that the report you created in the PBI desktop points to the correct server

2.Make sure the credentials on power bi service side are right

 

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

 

Highlighted
Regular Visitor

Re: Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

I tried several times, with no success.

 

1. Checked the credentials at PBI Desktop. It is working, I got data updated, no errors or warnings.

2. Deleted the workspace in PBI Online. Created from scratch.

3. Uploaded the dashboard and dataset.

4. Even the data is not showing any errors, I replace the credentials (with no errors), and I got the same error from the beginning:

 

Não é possível carregar o modelo
Não foi possível carregar o esquema do modelo associado a este relatório. Certifique-se que você tem uma conexão ao servidor e tente novamente.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
ID da atividade: d61cd717-649f-4b20-880d-4f1e0ce51ba0
Solicitar ID: 8c96807f-7dbb-79f1-fae6-a07e932d7840
ID de correlação: c6ea214a-8a21-0137-0e66-16d57f2f4663
Hora: Mon Jul 20 2020 11:05:35 GMT-0300 (Horário Padrão de Brasília)
Versão do serviço: 13.0.13913.66
Versão do Cliente: 2007.2.01968-train
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/

 

Also tried to upload a small table in PBI: same error.

 

It seems to be an issue with AzureSQL in Brazil region. Could you confirm if there is a limitation on that?

Highlighted
Regular Visitor

Re: Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

The cluster URI must be in the same region of AzureSQL?
In my case the cluster is: https://wabi-europe-north-b-redirect.analysis.windows.net/

Highlighted
Regular Visitor

Re: Data is not populated in PowerBI Online (The model cannot be loaded...). But Local is fine.

Despite the user and password were correct, the option of OAuth2 was checked, and instead to use the database credential, I think the service tried only to use the OAuth2.

 

After unchecking that option it worked!

 

 

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors