cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How do I pass on session-level user information to power BI?

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

2 REPLIES 2
Highlighted
Super User I
Super User I

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,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


Highlighted

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors