User data is great for setting up row-level security roles in Power BI. In this video, we get the profile data and manager for each user using Power Automate, then put it into a CSV file stored in SharePoint for easy access.
Have something else interesting you will use this data for? Let me know in the comments!
Here's the link for my preferred method for connecting to SharePoint for single files (mentioned in the video): https://youtu.be/2HZ8l23RXnc?si=sDt1Ibx6Fwx8vJl6
0:57 Create the flow
1:40 Get user profiles
2:45 Get managers
9:20 Send to CSV
🎓 COURSE
- I’m working on a course! Join the waitlist here if you’d like an earlybird rate and email when its ready: https://bi-ome.kit.com/waitlist
CONNECT WITH ME
📣 Get new videos via email! - https://bi-ome.kit.com/youtube
📝 Blog - https://christine-payton.com/
🔗 LinkedIn - https://www.linkedin.com/in/christinehpayton/
💬 Questions? Drop them in the comments! Your question could help others too.
Download
0 formats
No download links available.
Get ALL User Profile Data using Power Automate | NatokHD