Dataverse Datasource - DirectQuery - Cannot load model

[RyanDCox]

Hello,

I have set up a datasource using five tables from Dataverse. I am using directquery for the first time and am getting some issues as a result (for the purposes of this report, the data needs to be updated immediately, so import is not sufficient).

The majority of the data I need is in one table, so I tried to merge the columns I require from the other tables. Other than that, I am not really doing anything at the Power Query level. There are no relationships between the tables at the moment (I actually disabled load on the other tables but have now re-enabled, in case that was causing the problem).

The data loads into the report in desktop and seems to be fine. Even when a publish to a workspace, it all seems to be fine.

I get the following issues:

In the Power BI web portal, I get the following message when trying to load the report:

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.

Please try again later or contact support. If you contact support, please provide these details.

The dataset is refreshing each hour and seems to be working.

If I open the file in Power BI desktop, I get the following error:

Cannot load model

We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permissions to access them.

DirectQuery error: DirectQuery may not be used with the data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version.

Any help would be much appreciated.

Thanks,

Ryan

[v-yalanwu-msft]

Hi, @RyanDCox ;

Is this your report or someone else shared that report with you? Because I fount the same error in this post:

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

https://community.powerbi.com/t5/Service/Couldn-t-load-the-schema-for-the-database-model/td-p/148011

https://community.powerbi.com/t5/Service/Direct-Query-Couldn-t-load-the-model-schema-associated-with...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RyanDCox · Accepted solution]

Hi @v-yalanwu-msft,

Thanks for your suggestion. The issue actually turned out to be the changes I was making in Power Query. I unpivoted some columns. It didn't give me any errors when I made the changes but I guess unpivoting columns doesn't work with Direct Query. Thanks!