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,
I'm trying to createa dashboard using P_BI and it have created it, but would like the ability to filter based on the current user logged in to SharePoint Online. The reason for this is that the statistical data portrayed in the report comes from a SharePoint list for the whole department, so when the users go to it they can only see their own stats, not everyone elses.
I tried the steps on this link but it didn't seem to work.
Any ideas?
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You said it doesn't work, I want to know which parts don't work? You need to make sure you have user permission dataset to map with data, then you need to use USERPRINCIPALNAME ( ) in role setting in powerbi
If you use username(), you need to set map user in powerbi service.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You said it doesn't work, I want to know which parts don't work? You need to make sure you have user permission dataset to map with data, then you need to use USERPRINCIPALNAME ( ) in role setting in powerbi
If you use username(), you need to set map user in powerbi service.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dax how can i add the user permission dataset so that I can map with the data?
Hi @Anonymous ,
You could create permission like below
You could refer to introduction-to-row-level-security-in-power-bi for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |