"Cannot load model" - Power BI Live connection to AAS

[RubenKamphorst]

Hi All,

Normally this works seamlessly, but i've come accross the following warning when publishing the PBI Desktop file, which has a Live connection to an AAS Cube, to the service: "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".

The data model has been created in Visual Studio and deployed to AAS. I use the Azure Analysis Services database connector from within PBI Desktop. That works just fine. But whenever published, I cannot seem to access the report.

Any ideas? Do I have to add a certain role to the AAS Cube? Or does there need to be an app registration?

Thanks in advance!

[v-yanjiang-msft · Accepted solution]

Hi @RubenKamphorst ,

Have you configured the gateway? If not, follow the below steps:

1. Download and install the gateway on a local computer.
2. Configure the gateway based on your firewall and other network requirements.
3. Add a gateway data source.

Additionally, there is a very crucial point, The email address that you use to sign in to Power BI must match a defined user principal name (UPN) within the local Active Directory domain. The UPN is a property of an Active Directory account. The Windows account must be present in an Analysis Services role. If a match can't be found in Active Directory, the sign-in isn't successful.  

The map user names feature is a great way to work around when your user name in Azure Active Directory (Azure AD) doesn't match a UPN in your local Active Directory instance. For example, if your email address is nancy@contoso.onmicrsoft.com, you map it to nancy@contoso.com and that value is passed to the gateway.

To get to the UPN mapping screen, follow these steps.

1. Go to the gear icon and select Manage Gateways.

2. Select the data source, and then select the Settings button from the top ribbon.

3. In the Setting pane, you see a box with Map user names.

Reference: Manage your data source - Analysis Services - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

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