cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ScholesBI
Frequent Visitor

Cannot load model error

Hi,

I have the following setup: 

A SQL Database and an Excel are combined in a PowerBI dataset  "20210118".

Ultimately two reports 20210302/2021022 are connected to these datasets via direct query.

When I share these reports with other people in the organisation they receive the "Cannot Load Model error"

ScholesBI_2-1615291827604.png

 

 

ScholesBI_1-1615291591668.png

 

How can I share the reports without the error?

Has this something to do with the following: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas?

 

Thanks,

 

 

 

 

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

Hi  @ScholesBI  ,

The user opens the report shared in Direct query mode, and the gateway used by the person sharing the report needs to be used as a bridge to find the data source to obtain the data and datamode.
You can find the SQL server data source in Manage gateways-to see if the user is the User who owns the gateway data source of the SQL server.

v-yangliu-msft_0-1615451885993.png

If it is an AS, you may also need to map the user name of its user, because when the user interacts with the report connected to the AS, the email we use to log in to Power BI will be treated as a valid user name through the gateway to our local AS server. But, some users log in to the power bi account does not match the UPN in his local AD. So we need manual user name remapping.

 

This is the relevant document, I hope to help you:

Add users to the data source:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

About AS mapping:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

Manage AS data sources:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

 

Best Regards,

Liu Yang

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

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @ScholesBI  ,

The user opens the report shared in Direct query mode, and the gateway used by the person sharing the report needs to be used as a bridge to find the data source to obtain the data and datamode.
You can find the SQL server data source in Manage gateways-to see if the user is the User who owns the gateway data source of the SQL server.

v-yangliu-msft_0-1615451885993.png

If it is an AS, you may also need to map the user name of its user, because when the user interacts with the report connected to the AS, the email we use to log in to Power BI will be treated as a valid user name through the gateway to our local AS server. But, some users log in to the power bi account does not match the UPN in his local AD. So we need manual user name remapping.

 

This is the relevant document, I hope to help you:

Add users to the data source:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

About AS mapping:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

Manage AS data sources:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

 

Best Regards,

Liu Yang

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

Thank you for your help. However solution was that the reports were shared without granting access to the related workspace. In this way users will not see the content. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors