Forum Discussion
Get data from Microsoft teams (shifts)
Hello sjb9:
In my application I ussed an OData feed to directly query the Graph (beta) API directly into PowerBi. The data is then updated when the report is refreshed. Have not yet worked with "Flow". The user is currently refreshing the reports as needed as a short term solution. Hope this helps.
= OData.Feed("https://graph.microsoft.com/beta/teams/your teams ID #/schedule", null, [Implementation="2.0"])
Update to my own question for other users. This does work. Use an "ODATA" connection to the Graph API ( beta ). Only the beta API has the shifts data. You can then expand the lists that are returned from the API. We are actually using the shifts time data to cross filter other data in PowerBi via a calculated column in DAX.
Anonymous Can you please explain a bit more about how you moved the data retrieved from the graph into PowerBI?
On Power Automate (Flow) I can only see the add to existing data set action for PowerBI.
Did you move the retrieved data somewhere else first, like a CSV file, or did it go straight into PowerBI.
Thanks
Hello sjb9:
In my application I ussed an OData feed to directly query the Graph (beta) API directly into PowerBi. The data is then updated when the report is refreshed. Have not yet worked with "Flow". The user is currently refreshing the reports as needed as a short term solution. Hope this helps.
= OData.Feed("https://graph.microsoft.com/beta/teams/your teams ID #/schedule", null, [Implementation="2.0"])
v-xuding-msftCommunity Support
Hi Anonymous ，
Thanks for sharing the solution!