Default PowerBI Dashboard based on User UPN

[sgsukumaran]

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?

[Anonymous · Accepted solution]

@sgsukumaran

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.