Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Hopefully a somewhat simple question. I am in the midst of building an internal activity dashboard for my team, and was looking if there was a way to grab status (or "User Presence" as defined by Microsoft) information from Office 365 and import it into Power BI desktop to use within my dashboard (i.e. Team member A is available, Team member B is in a meeting, Team member C is out of Office). We would use this to track who has an "out of office" status on any given day. What is the best way to go about importing this piece of information for my organization?
Thanks in advance!
Solved! Go to Solution.
"What is the best way to go about importing this piece of information for my organization?"
You described the issue very well. Importing will not help you. Importing in Power BI is done sporadically. Presence information changes dynamically. Your only chance at implementing this is to use an external tool that polls that data frequently, and then to have a Direct Query (not Import!) connection from Power BI to that data source.
"What is the best way to go about importing this piece of information for my organization?"
You described the issue very well. Importing will not help you. Importing in Power BI is done sporadically. Presence information changes dynamically. Your only chance at implementing this is to use an external tool that polls that data frequently, and then to have a Direct Query (not Import!) connection from Power BI to that data source.
Hi,
Thank you for the reply! That is a good point, I can try to look at connection tools for this functionality, but wanted to make sure I wasn't missing an easier solution.
I think import mode would still work for my specific use case, as the only thing I am looking to display is "Any user who's status is out of office" which is set by the day, so as long as my data refresh is in the morning, then that data would be correct. Obviously the presence information itself would would be static, but that is ok for my use case. Regardless, if it is not possible in import mode, then I will look at connection tools to try to directQuery it instead. Do you happen to know of any resources to help me out?
I did provide a link to the Graph API. That should get you going. Let me know where you are stuck.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |