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

The 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.

Reply
Anonymous
Not applicable

"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 @Anonymous ,

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 @Anonymous ,

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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