When a user logon to PowerBI Portal, He/She should see only dashboard for them for their UPN. The dashboard is built on SSAS tabular model. how to accomplish this?.
My assumption is that UPN is their email Address. Is it different and how can I see their UPN details?
Power BI is based on the users credentials. You are correct in the UPN being the mapping from on premises AD to AAD.
It largely depends on what you mean with they should see only the dashboard for them.
First, you need to create the report/dashboard. Then you need to share it with that user. You can share it via an AD security group in which that user is a part of, or directly to the user. Then the user will see it in their workspace when they log in.
If you are implementing Row Level security in your model, the same actions apply above, only the user will automatically be filtered to see only what they should - as long as you are connecting to the SSAS tabular model via Direct Query. If you import, you would nede to build the RLS in the Desktop.
So. Create report in Desktop. Publish to Workspace. Create Dashboard. Pin Visuals. Share Dashboard.
Thanks. The users already have access to the model but now i am tryng to filter data based on their powerbi login.
Here is what i have tried. Created upn table with user details & login email address and incorporated in the model. Also created a dax filter like this
='Ownership'[Merchant]=LOOKUPVALUE(UserUPN[Merchant], UserUPN[UPN], USERNAME(), UserUPN[Merchant], 'Ownership'[Merchant])
I was expecting the RLS to work as it is in the model and report.
@sgsukumaran Ah. I understand what you are asking now. The UPN is converted to your Windows creds. The users values should be set up as Domain\UserName. Check out this walk through here. Task 6 talks about the conversion of effectiveusername when connecting to the model. While this example is for SSAS Tabular models, the same rules apply in the Desktop (Because it is also a Tabular model)
The UPN is through enterprise gateway for Powerbi online portal and it is managed through groups. Anyway to identify individual users by login?
@sgsukumaran Yeah, it all just works. Power BI knows who the end users are because they have to log into their own workspace, have to have a Pro license, etc. So if you manage the distribution of the report by sharing to a security group, it still knows who the users are when they access the report.
I tried all possible filters using dominname/username and email combinatio. Nothing seems to get fitered though. Any good refernce on how to filter users based on login in tabular?
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!