Forum Discussion
Couldn't load the schema for the database model
My user gets this error when I share a dashboard with them. The are outside the organization. Do they need to have a Power BI Pro licence? Please help.
Please try again later or contact support. If you contact support, please provide these details.
Solved! The reason why you are getting that error is because you sent a dashboard with "Pro" content to someone who does not have a "Pro" license. https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/
12 Replies
Hi there,
I have the same problem with my dashboard sharing with my client. Have you figure out how to solve this? Can anybody give a hint? I used SQL server as my data source and I did not see user map options either.
Thanks!
Solved! The reason why you are getting that error is because you sent a dashboard with "Pro" content to someone who does not have a "Pro" license. https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/
I've been having the same issue with multiple dashboards I have shared with our clients, who are outside the organization.
In one case, the users had signed up for the free 60 day trial of Power BI Pro and get the message:
Couldn't Load the Schema for the Database Model.
In another case, the user's Power BI Pro trial expired, but they now have a subscription to Power BI Pro and still get the same error message (effectively, what appears to be a security issue from scanning other posts).
Some assistance would be greatly appreciated.
- I get this error when I share this dashboard outside my organization. Do they need to have a BI Pro Licence?Couldn't load the schema for the database modelCouldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.Activity IDc0229046-ff5e-4ddd-bb71-2088cb2bc6d7Request ID02eba4de-aaed-553f-c63a-2192eefac90bCorrelation IDc12e1da1-b596-274a-9a95-b2884335973bTimeThu Mar 23 2017 11:57:17 GMT-0700 (Pacific Daylight Time)Version13.0.1700.1501As per the online documentation,
You can’t share dashboards that contain Power BI Pro content with external users who have a Power BI Pro trial license. They need regular Power BI Pro licenses to access those dashboards. What is Power BI Pro content?
As to the error, what tiles are in that dashboard? The errors seems specific for UPN mismatching when connecting to SQL Server Analysis Service.
I have tiles from a SQL Server data source. Please see the images below. I have this data source setup as SQL Server. I read the article on "Mapping the UPN". There is nothing to map a UPN in powerbi.com.
How the data source is setupUsers. There is nothing to map the UPNIndividual outside my organization error
I am getting the same error with embedded reports using Azure AS. None of the solutions above are viable for me
Do your users have a Pro license?
I solved my problem. I guess you can't use embedded with Azure AS yet
Uncheck the option: "Report viewers can only access this data source with their own Power BI identities using DirectQuery" in "Data Source Credential". To learn more and see picture where its located: https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect#single-sign-on
i was using 'window authentication' in my gateway datasource in powerbi. however I didn't have password in my PC so I was seeing this error. Also, I had checked 'skip test connection' because 'test connection' requires password.
What did I do?
1. firstly, I setup a password on my windows pc.
2. secondly I selected 'window authentication' and entered my window PC name and password and keep 'skip test connection' unchecked.
I was using datagateway for directquery, and I also kept 'sso via kubernet' things unchecked. they might cause problems sometimes.
