Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
Gianca
Frequent Visitor

RLS in composite mode

Hi,

 

I'm tring to set up the RLS in composite model, but seem not working correctly.

 

I'm also using a Gateway to connect on-prem data.

 

At first i did a test creating a DataSet and a Report with the RLS .I gave access as Viewer to a my collegue.

 

He tested that correctly see the data.

 

Then I created an other report with a composite model connecting to the previous shared Dataset (with the RLS defined before).

 

The user cannot see anything and the following message is diplayed:

 

Anyone could help me to understand the problem?

 

Gianca_0-1647855945106.png

 

 

 

Thank you

 

Giancarlo

 

 

1 ACCEPTED SOLUTION
Gianca
Frequent Visitor

Hi,

           I've found the solution and the problem wasn't strictly related to the RLS, but to the composite model.

 

In the composite Model you have the shared dataset + the report dataset

 

You need to define security as follow:

 

Shared Dataset  as  Viewer+Build

 

Report dataset as Viewer

 

 

Here the article that helped me:

 

https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-mod...

 

Thanks

 

Giancarlo

 

View solution in original post

3 REPLIES 3
otravers
Community Champion
Community Champion

For people ending up on this page via Google, this is no longer needed since April 2022 in Premium workspaces (not sure about the current status for Pro though):

https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
Gianca
Frequent Visitor

Hi,

           I've found the solution and the problem wasn't strictly related to the RLS, but to the composite model.

 

In the composite Model you have the shared dataset + the report dataset

 

You need to define security as follow:

 

Shared Dataset  as  Viewer+Build

 

Report dataset as Viewer

 

 

Here the article that helped me:

 

https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-mod...

 

Thanks

 

Giancarlo

 

v-xiaoyan-msft
Community Support
Community Support

Hi @Gianca ,

 

It would be great if you could provide more details.
What is your data source? Which two connection modes are you using for your composite model?
Generally, this type of error occurs when users are using DirectQuery for Power BI datasets and Azure Analysis Services .
There are known limitations:

  • RLS rules will be applied on the source on which they are defined, but will not be applied to any other datasets in the model. RLS defined in the report will not be applied to remote sources, and RLS set on remote sources will not be applied to other data sources. Also, you cannot define RLS on a table from another source group nor can you define RLS on a local table that has a relationship to another source group.

 

  • KPIs, row level security, and translations will not be imported from the source in this preview release.

  • Users need 'Build' permissions on all datasets in the chain to access a report that leverages this feature.

 

For more,you can see:Considerations and limitations 

 

 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.