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.
I believe , below is your exact requirement.
- You have role named "Project Manager"
- You have different Project manager like "A","B","C".
Now, if PM "A" logins then they can see only their data in visuals.
If PM "B" logins they can view only their data.
If I my understanding is correct -
1. You can use a concept of Row level security in Power BI.
2. Create role in PBI.
3. Apply condition on data model.
Hii
If your SharePoint Office 365 login and Power BI login will same , then it will be managed automatically by Row level security.
Ex: If user login with SP using "abc@pm.onmicrosoft.com" and PBI using the same "abc@pm.onmicrosoft.com" ,
But the visuals for every PM will be same. Data filled in those visuals will be different.
Suppose, I have barchart and column chart in my PBI report.
Now, If PM "A" login in PBI he can view "barchart" and "column chart" with their assigned project data.
Same for PM "B".If PM "B" login they can view barchart and column chart with their assigned project data.
Refer below URL:
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |