Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello ,I wan to implement a Power BI Embedded solution to one of our customers .
The customer request to separate the Report into 17 groups (with multiple users in each group) ,the Report have to upload into customer's application , each one of users will login into app has to see the data of his/her group .So ,there are two solutions :
1.) to implemet RLS per group
2.) to create 17 workspaces ,each one for one group.
The Report will generate from one semantic model .
First ,which is the best solution ?
Second ,please i need related links of how can implement the solution step by step .
Thanks in advnace ,George
Solved! Go to Solution.
Thank you ibarrau
Hi, @GeorgeKarl
If you want to use RLS to embed for your customers, you can check out this master plan document below:
In this article, we will focus on establishing the relevant RLS rules when designing reports in Power BI desktop. How to write DAX expressions for these rules describes the two options you can have: dynamic RLS and static RLS.
The main difference between the two types is the use of DAX functions (username, userprincipalname). If you choose this method, you need to test what the two functions return in your environment.
Static RLS filters data based on a column in your data.
You can then refer to the following RLS design overview:
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
This article will look at how to create an RLS persona, and how the model is designed directly, the connections of relationships, and how RLS filters your data. You need to understand it and then practice it, and when you have some RLS roles set up in Power BI Desktop based on your model, then you can apply it in Power BI Service.
To apply RLS in Power BI Service, you can refer to the following documentation:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you ibarrau
Hi, @GeorgeKarl
If you want to use RLS to embed for your customers, you can check out this master plan document below:
In this article, we will focus on establishing the relevant RLS rules when designing reports in Power BI desktop. How to write DAX expressions for these rules describes the two options you can have: dynamic RLS and static RLS.
The main difference between the two types is the use of DAX functions (username, userprincipalname). If you choose this method, you need to test what the two functions return in your environment.
Static RLS filters data based on a column in your data.
You can then refer to the following RLS design overview:
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
This article will look at how to create an RLS persona, and how the model is designed directly, the connections of relationships, and how RLS filters your data. You need to understand it and then practice it, and when you have some RLS roles set up in Power BI Desktop based on your model, then you can apply it in Power BI Service.
To apply RLS in Power BI Service, you can refer to the following documentation:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello ibarrau and thank you so much for your reply !
Could you please help me how can i connect RLS roles (based on deprtment ) with credential of each user for UI which power embedde will upload it ?
Hi. I would go with RLS solution. Keep it in a single semantic model with roles. You can play with embedded code solutions at: https://playground.powerbi.com/en-us/
I don't think you will find a link with the whole solution of what you want. There are third party tools selling that kind of product, so it would be weird if there is an article showing it all.
I hope that helps,
Happy to help!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
22 | |
21 | |
19 | |
10 |
User | Count |
---|---|
37 | |
36 | |
34 | |
20 | |
14 |