Cannot Load Model – MSOLAP Connection Error When Embedding Power BI Report

[deepuaits]

Description: I am encountering an error when trying to load a Power BI report embedded in my application. Couldn't load the model schema associated with this report.

Could you please suggest possible troubleshooting steps and best practices to resolve this issue.

Thanks,

Pradeep

[v-karpurapud]

Hi @deepuaits 

We would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.

Thank you.

[v-karpurapud]

Hi @deepuaits 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @GeraldGEmerick , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the shared details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team.

[GeraldGEmerick · Accepted solution]

@deepuaits Might be obscure, but check this issue: Solved: Re: Failed to open the MSOLAP connection. - PowerB... - Microsoft Fabric Community

Additional possibilities:

• Check Permissions: Ensure that the service principal or user account has the necessary permissions to access the XMLA endpoint of the dataset.
• Correct Authentication Path: Verify that the correct authentication path is being used to access the dataset.
• Service Principal Settings: If using a service principal, ensure that it has service principal access enabled at both the tenant and workspace levels.
• Move to Supported Workspace: If the dataset is in a PPU workspace, consider moving it to a Premium (Fabric) capacity workspace or using a user account token instead of the service principal.