Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks. Hope everyone is having a good day so far. In our organization, we have a web portal where different sales reps login using their own credentials. In the same portal, we want to show a Power BI report. For that, I searched around and found that Power BI Embedded is the best suitable option. Screenshot for reference:
The option highlighted in red is the only option for us. However, there's one more additional requirement - after login, each sales rep should only be able to access the data relevant to their sales office. Using the login credentials, the web application can determine which office the sales rep belongs to (by running a query against the database). Afterwards, in the embedded report, we want to restrict the data just to that sales office. Is this possible ? Has anyone achieved anything similar to this ? Any help is appreciated. Thanks in advance.
P.S. : Tagging some of the most knowledgable members. I hope that doesn't offend anyone. If you think that was unprofessional, my apologies. 😅
@GilbertQ @lbendlin @v-yetao1-msft
Solved! Go to Solution.
Hi. It sounds like an RLS solution. Row level security is a Power Bi feature that allows you to create rules for users. Those rules (DAX code) will filter the current model.
You can read more in microsoft doc: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
That will show how to implement it.
Here you have a second link in case you feel that the first documentation won't work because you have too many sales office to create rules. There are ways to make it dynamic but it might be a little more complex: https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla
I hope all of that helps you
Happy to help!
Hi ,
I am trying to embed a power bi report with an application based on .net ,sothat when a user logs in he/she can see only his data in the report in that application . I have followed the AppsOwnData Approach and using embedding environment i have downloaded the sample application.
So my query is In that particular solution what are the changes i have to do for the interaction to be happen as the application is already available ..i have made the changes for web.config file like giving the report id,application id and so on but what are the other code level changes i have to do...could you please guide .. @ibarrau
Hi ,
I am trying to embed a power bi report with an application based on .net ,sothat when a user logs in he/she can see only his data in the report in that application . I have followed the AppsOwnData Approach and using embedding environment i have downloaded the sample application.
So my query is In that particular solution what are the changes i have to do for the interaction to be happen as the application is already available ..i have made the changes for web.config file like giving the report id,application id and so on but what are the other code level changes i have to do...could you please guide ..
Hi. It sounds like an RLS solution. Row level security is a Power Bi feature that allows you to create rules for users. Those rules (DAX code) will filter the current model.
You can read more in microsoft doc: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
That will show how to implement it.
Here you have a second link in case you feel that the first documentation won't work because you have too many sales office to create rules. There are ways to make it dynamic but it might be a little more complex: https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla
I hope all of that helps you
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.