How do I pass on session-level user information to power BI?
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.
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.
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.