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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
thebigwhite
Helper II
Helper II

Power BI DataMart

Good morning, I would like to have some tips on how use power BI datamarts effectively in a Company Scenario: 

- I would like to give the possibility also to the users to build "no official model" also with local data. 

The problem for me is that the row level security must be managed by the ICT department. What I would like to do is to provide them Dataflows that can be used also in a datamart scenario but the row level security cannot be managed by the users. 

How do you face this scenario?

3 REPLIES 3
Anonymous
Not applicable

Hi @thebigwhite 

I don't quite understand that you said not bypass the rls security ? If users can build their reports based on your dataset , that means RLS not work for them .

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi @thebigwhite 

So, you mean to allow users to use your dataset to create their own reports ? In this case, RLS doesn't work because RLS doesn't work for users with edit permissions on the dataset, it only works for users with view permissions . Let users create their own reports from the dataset you provide, you can refer to the following documentation . 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-share 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks for the answer. What about the datamarts scenari?

I am already using the solution of dataset (users are building reports from certified dataset).

Can the user create their own datamart but not bypass the rls security?

Thanks

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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