Forum Discussion
Dynamic RLS with AD Security Groups - best practices and app sharing?
Hi, Vegard1985
It’s my pleasure to answer for you.
According to your description, I think you have great ideas. If your reports needs to be distributed to users with different permissions to see different data, RLS can indeed be used, and it is inevitable.
In the recent update, it has been supported to connect powerbi dataset and other data sources at the same time.
LInk:Power BI December 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
After setting up RLS, you can publish an app, add the "all employees" group you mentioned, and then they will see different content according to the permissions you set, and other users outside of RLS can access the report, but they can't see all the data.
Remember not to give the user build permission of the dataset or edit permission of the report, otherwise RLS won't work.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Vegard1985
It’s my pleasure to answer for you.
According to your description, I think you have great ideas. If your reports needs to be distributed to users with different permissions to see different data, RLS can indeed be used, and it is inevitable.
In the recent update, it has been supported to connect powerbi dataset and other data sources at the same time.
LInk:Power BI December 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
After setting up RLS, you can publish an app, add the "all employees" group you mentioned, and then they will see different content according to the permissions you set, and other users outside of RLS can access the report, but they can't see all the data.
Remember not to give the user build permission of the dataset or edit permission of the report, otherwise RLS won't work.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Janey - thanks for your input! 🙂 I'll be suer to double check the build permission!
Hello,
I just read this reply, well mostly the big red line. I am currently helping to start setting up a Self Service BI environment. Does that mean there is no way to use one model for multiple people with different access to data?
If not, are there any upcoming projects to deal with this?
Kind regards
