Forum Discussion
Get data on users and their managers
Hi guys.
I really need help. I am currently working on a small project regarding registration of- and presenting of project time consumption.
I have created a Sharepoint Online list for holding the registraions data. I now need to create i Power BI report based on the list.
Users of the Power BI report are the managers of the people registrating in the Sharepoint list. They need to be able to filter the report by "Manager" in order for the to only see data conserning themselves.
Are there any way of retreiving a list of 365/Azure users and their managers? I have tried connecting to MS Graph but apperently Microsoft stopped this service a while back.
Any ideas?
6 Replies
- lbendlin
Super User
The Sharepoint User Information List only captures the manager of a user at the point of user creation. Depending on the size of your organization you can use the ActiveDirectory connector in Power BI to pull the hierarchy, or maybe your company has a ready made regular extract available that you can use?
- mahoneypat
Microsoft Employee
Not sure what fields are populated at your company, but the manager field is sometimes available through the SharePoint List connector, if it is a People/Group column in SharePoint. When you expand the Author or Created By/Modified By field, do you see that option?
Regards,
Pat
Hi Anonymous
If you want to set permission to restrict user get your data source by role, you can refer to this blog:
Customize permissions for a SharePoint list or library
If you want to restrict the user to view your report you can set Dynamic Row Level Security in your power bi desktop and add roles in your service.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
