cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

Accepted Solutions
Highlighted
Super User IV
Super User IV

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

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Highlighted
Community Support
Community Support

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

Hi @rstahura ,

 

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
Highlighted
Super User IV
Super User IV

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

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Highlighted
Community Support
Community Support

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

Hi @rstahura ,

 

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

Highlighted
Community Support
Community Support

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

Hi @rstahura ,

 

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors