Getting Error Cannot load model

[ManasRout]

Hi Team, While publishing a report in power bi service getting error Cannot load model but in power bi desktop I can able to open it and refresh it manually. In power bi service I saw gateways are in online as well as connection is online what could be the reason for getting this issue and how to resolve it. For data source credential up to date as admin has granted  access credentials are not require.

[v-dineshya]

Hi @ManasRout ,

Thank you for reaching out to the Microsoft Community Forum.

The error refers, the Power BI Service could not initialize or load the semantic model, because something failed inside the service during model processing.

Please try below things to fix the issue.

1. Please try to Re-authenticate the OAuth connection manually.
2. Please disable “Allow report readers to use the model”. If multiple users open the report at the same time, SSAS engine can choke.
3. Please enable “Enhanced Refresh” and incremental refresh. This reduces load on the service side.
4. Please move your workspace to a stable capacity, if you are using shared capacity.

Note: It is a backend issue either OAuth token renewal or SSAS instance.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @ManasRout ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[ManasRout]

Hi @v-dineshya this issue resolved automatically on the next day after scheduled refreshed. I didn't do anything from my end.

[v-dineshya]

Hi @ManasRout ,

Thanks for the update. We are happy to hear that  issue got resolved. 

Regards,

Dinesh

[ManasRout]

Hi @v-dineshya , @Natarajan_M , Again I am getting same error for another report while publishing in power bi service. What could be the reason I have checked the credentials are up to date and on premises service and connections are online. Still getting same issue.

[v-dineshya]

Hi  @ManasRout ,

It appears this issue might require deeper investigation from the Microsoft  Fabric support team. I recommend opening a Microsoft support ticket so they can trace the issue. To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Regards,

Dinesh

[v-dineshya]

Hi @ManasRout ,

We are following up to inquire whether you have raised the support ticket. If you have already done so, we kindly request you to share your feedback regarding the issue raised.In case a solution has been provided, we would be grateful if you could share it with the community. This will assist others facing similar challenges and benefit the wider community. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Regards,

Dinesh

[ManasRout]

Hi @v-dineshya , Thank you for the steps I am using older version of power bi desktop let me updated to latest version and check if it will still not work then I will create a support ticket to microsoft team.

[v-dineshya]

Hi @ManasRout ,

Thank you for the update, once you have done testing, Please do let us know.

Regards,

Dinesh

[Natarajan_M]

Hi , @ManasRout , 

Check the gateway and the connection details under the semantic model settings to ensure all sources are authenticated properly. I also came across the same issue reported by another user; check this if it can help.

https://community.fabric.microsoft.com/t5/Service/Couldn-t-load-the-model-schema-associated-with-thi...

[ManasRout]

Hi @Natarajan_M , Thank you for providing the above steps but suddenly today I checked the report is opening without any issue. For this report I am using credential OAuth I don't what happened it open on today automatically.