Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
RubenKamphorst
New Member

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

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!

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

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.

vkalyjmsft_0-1654224950391.png

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

vkalyjmsft_1-1654225141525.png

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

vkalyjmsft_2-1654225387630.png

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.

View solution in original post

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

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.

vkalyjmsft_0-1654224950391.png

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

vkalyjmsft_1-1654225141525.png

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

vkalyjmsft_2-1654225387630.png

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors