Forum Discussion

RyanDCox's avatar
RyanDCox
Frequent Visitor
4 years ago
Solved

Dataverse Datasource - DirectQuery - Cannot load model

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 nee...
Need Help
  • RyanDCox's avatar
    RyanDCox
    4 years ago

    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!

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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-this/m-p/953163


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's avatar
    RyanDCox
    Frequent Visitor
    4 years ago

    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!