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.
Hi
Does Power BI still not support separate prompt pages?
Does Power BI support filtering before the user looks at the data? We have prompt pages that use filtering to make sure users only see their data in the tables. Does Power BI have this, or would we need to create separate tables for each user?
Thanks.
Solved! Go to Solution.
@vnicholl
You just need to use Dynamic RLS with userprinciplename(). With this setting, if you just add users to the RLS role, users would only see their data.
DAX USERPRINCIPALNAME - Use in RLS - Power BI Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@vnicholl
You just need to use Dynamic RLS with userprinciplename(). With this setting, if you just add users to the RLS role, users would only see their data.
DAX USERPRINCIPALNAME - Use in RLS - Power BI Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
I depends on what you mean by "prompt pages". You can configure the first page of your report with a set of common slicers that are synched to your other pages so the users set a filter at the start and then that flows through to all the other pages.
Or if this is a security requirement you can use RLS https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls to give different users a different filtered view of the data
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.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |