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
Anonymous
Not applicable

Sharing Reports With Multiple External Businesses(20+) with only 1 dataset

We have an interesting setup right now where we provide a couple reports to each of our customers(Our customers are businesses and we have more than 30 of them, continually growing). I've been trying to find the most efficient way to do so while at the same time prevent them from ever having access to the data from other businesses. 

 

As I understand it, I  setup a new Row Level Security role for every business that we send reports to. Does anybody have any other pointers? The number of businesses we work with is constantly growing, so each time we add some I'll have to download the dataset, create a new role, re-upload then add them to the role. 

 

In summary, my challenges are .. protecting the data while using only one dataset and sharing reports from that dataset with 20+ different external groups.

 

Everything I've learned has pretty much come from the community so I figured I'd ask y'all. 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Yes, this is pretty much how I have seen smaller businesses doing this. There are some good posts out there on dynamic RLS


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Just as what @Greg_Deckler says, you can try to use Dynamic RLS. Hope these documents and videos could help you:

Dynamic Row Level Security with Power BI Made Simple;
Dynamic Row Level Security (Dynamic RLS);
Using dynamic row-level-security with organizational hierarchies;
Power BI Dynamic Row Level Security 1;
Power BI Dynamic Row Level Security 2.

 

 

Best Regards,

Icey

 

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

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.

 


Best Regards
Icey

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Just as what @Greg_Deckler says, you can try to use Dynamic RLS. Hope these documents and videos could help you:

Dynamic Row Level Security with Power BI Made Simple;
Dynamic Row Level Security (Dynamic RLS);
Using dynamic row-level-security with organizational hierarchies;
Power BI Dynamic Row Level Security 1;
Power BI Dynamic Row Level Security 2.

 

 

Best Regards,

Icey

 

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

Greg_Deckler
Super User
Super User

Yes, this is pretty much how I have seen smaller businesses doing this. There are some good posts out there on dynamic RLS


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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