Problem With RLS - The report cannot be displayed because the underlying dataset uses RLS (Row-Level

[Edgar_massa]

Here’s the situation: I have a PBIX where I pull data from Databricks, and I’ve set up an RLS rule, which serves only as a baseline.

I have other PBIX/Reports connected to the PBIX I mentioned above (PBIX was created on the front end because I created parameters on the front end, so PBIX was generated, and it went from a live connection to a mixed model). These reports contain the visuals and so on.

I added 3 groups to the PBIX security in the Power BI service, which contain the users, and granted read permission to those 3 groups for the PBIX data and the front-end PBIX. The app is available to the entire company.

There is one area that cannot access it, which is the operations department; every time they open the report, the message “The report cannot be displayed because the underlying dataset uses RLS (Row-Level Security)” appears.

I have already validated the emails. It’s OK.

I’ve already validated it by testing the email in PBIX. It’s OK.

I’ve already validated it by testing the email in the RLS rule. It’s OK.

I don’t know where else to look.

Screenshots below

[v-hjannapu]

Hi @Edgar_massa,
I hope the information provided by @GilbertQ  assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

[v-hjannapu]

Hi @Edgar_massa,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

[GilbertQ]

Hi @Edgar_massa 

Unfortunately, as far as I am aware, it is not possible to have value of security on composite models.  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#considerations-a... 

[Edgar_massa]