Forum Discussion
Teams Shift Reporting in PowerBI
For a couple of years now I've been using PowerBI to aggregate monthly Teams Timeclock and Shifts exports so I can see Shifts data across multiple years with some really useful measures and reports f...
Hi,
I am actually interested in doing something similar to this (creating a PowerBI report leveraging Microsoft Shifts data).
I am curious how you leverage the exports in your report? As in, do you take the data and drop it into some table, or are you using those files as the source themselves?
I am actually interested in doing something similar to this (creating a PowerBI report leveraging Microsoft Shifts data).
I am curious how you leverage the exports in your report? As in, do you take the data and drop it into some table, or are you using those files as the source themselves?
Hi!
I’m currently using the ‘Folder’ datasource in PowerBI desktop because it will process all Shifts exports in that folder so no action is required other than putting a new file to that location.
Downside is it’s only available on PowerBI desktop… which is why I’m currently looking to automate the export into Dataverse by using Graph API.
I’m currently using the ‘Folder’ datasource in PowerBI desktop because it will process all Shifts exports in that folder so no action is required other than putting a new file to that location.
Downside is it’s only available on PowerBI desktop… which is why I’m currently looking to automate the export into Dataverse by using Graph API.