Composite Model: Coult Not Load the data for this visual

[Cbischel]

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!

[GilbertQ]

Hi @Cbischel 

As per the details in the link below, the RLS can only be applied on the source dataset. On a chained dataset RLS will not work

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn