Connect Power BI to Shifts Data
Hi, I would like to connect Power BI to Shifts data in order to be able to make reports from Shifts having real time data available.
surbhi nahta commented
Thanks for the useful information.
I am searching this type of information about this from long time but didn't find the exact one that i wanted.
PLEASE allow Shifts to connect with PBI outside Flow-based expressions. This would allow for real-time personnel dashboards and status tracking for large enterprise operations.
We need access to the time card data
This can be done with an ODATA connector in PowereBI to the Graph API (beta). We have this working and are using the shifts data as a cross filter for time series data in PowerBi. Not as nice as a native connector but it does work.
Please, can someone help!
-> I take OData in PowerBI
-> what do I have to write down?
I found my teams ID with microsoft graphs, but I do not find my shift ID.
I am already looking for some weeks and helpdesk microsoft can not help me... :(
Just an update: This is possible by using an OData Feed in PowerBi. I have it working. Only available in the Beta verion of Graph API. Using the shifts data to cross filter machine performance data in PowerBi. Have to join the Schedule Groups to either the Open Shift or Shift or both.We are not assigning the shifts so we are using the Open Shifts Table.
is it available now?
It can´t be difficult for you guys! shifts it´s already doing it, at workers per half hour when day view. Permit connect with power bi to know how many people do we have per hour in power bi should be easy for you masters of IT!
Agreed. It will be easier to export reports instead of manually extract the data.