Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
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!
Hi , @Anonymous
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.
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?
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/
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!
User | Count |
---|---|
47 | |
27 | |
21 | |
19 | |
18 |
User | Count |
---|---|
54 | |
47 | |
22 | |
22 | |
20 |