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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DataJoe
Frequent Visitor

Data security on premisis premium solution

Hi all,

 

I have a security question regarding best practice on my PowerBI solution.

 

Our setup as if today; Data Warehouse to Power BI by a dataset.

 

We are going to have 150+ reports, where some users should see all, some a bit and some only 1 or 2 reports.

 

1000+ workspaces and filters in reports is not an option 😉

 

Should I go with RLS, AD or a 3. option?

 

Thanks in advanced.

 

 

 

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @DataJoe 

 

Without a doubt to use DRLS, this will enable you to create the dataset once and no matter how the users access the data they will ONLY be able to see the data that they have got access to.

 

Here is my blog post explaining how to do DRLS with AAD Security Groups: Dynamic Row Level Security is easy with Active Directory Security Groups - Reporting/Analytics Made ...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @DataJoe yes you will as long as it is in the same underlying dataset.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @DataJoe 

 

Without a doubt to use DRLS, this will enable you to create the dataset once and no matter how the users access the data they will ONLY be able to see the data that they have got access to.

 

Here is my blog post explaining how to do DRLS with AAD Security Groups: Dynamic Row Level Security is easy with Active Directory Security Groups - Reporting/Analytics Made ...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi GilbertQ,

 

Thanks for the link and explanation.

 

If I go with DRLS and ADD, will I be able to apply these seruciry settings on already developed in different workspaces?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors