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.
Hello,
We are developing an web application where we intend to use power BI embedded to present the user with dashboards and reports but only with data that the user ought to see. The data will most probably be obtained from an API. I have read the different solutions around parameters but I am a bit confused if this a valid solution for me. My worry with making use of parameter(s) is that if more than 1 user is accessing power BI, they will be presented with the same data. Is that so?
What would be a good solution for my case? Does a valid solution exist currently with power BI embedded? Highly appreciate if the community can help me with this.
Cheers
Hi, I'm not an embedd expert but I think you should use RLS. When you embed a report with Roles configurated in RLS option you can send in the parameter of the embed method in the code the role for it. That way the report will be filtered by the condition in the role inside Power Bi Desktop. You can create role by conditions or create a users table related with their roles. It will be a dax logic.
To read more about it: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Hope this helps,
Happy to help!
Thank you @ibarrau
But after going throught the documentation and trying RLS, I believe it is not possible to fulfll the scenario I have right now with powerBI.
RLS is ok if you already know all your users in advance and can clearly define which part they have access to and with part they ought not have access to. However, in the case of web application, where users can register and deregister in a dynamic way, I don't see how RLS can be a solution.
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.