Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Yes, this is pretty much how I have seen smaller businesses doing this. There are some good posts out there on dynamic RLS
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.
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
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.
Yes, this is pretty much how I have seen smaller businesses doing this. There are some good posts out there on dynamic RLS