Forum Discussion

Cbischel's avatar
Cbischel
Frequent Visitor
3 years ago

Composite Model: Coult Not Load the data for this visual

Hi All,

 

I have a composite model that uses multiple Power BI datasets (published in the PBI service) with some basic RLS to scope the data down by user. When I test RLS in Power BI Desktop the report works great but when I publish the report to the Power BI service and test as a user all visuals in the report show the error below. My users also confirm seeing this error for all visuals in the report.

 

 

These are the things I have tried to do to correct the issue:

  • I have given the users viewer permission to the workspaces
  • build permission to the datasets involved
  • I also confirmed with my O365 Admin that XMLA endpoints have been enabled
  • Tested with users who have a pro license (in case that somehow mattered)

The issue still persists after completing each of these requirements. Does anyone have other ideas for things to try that would let my users view the report in the Power BI service based on a composite model?

 

Below is a snapshot of the report schema.

 

And the RLS I am implementing that works in Desktop

 

Thanks!