Forum Discussion

jmoreyproadata's avatar
jmoreyproadata
New Member
7 years ago
Solved

Get data from Microsoft teams (shifts)

How to connect power bi to microsoft teams, extracting information from app shifts that its use from create timetable.
General Comment
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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"])

sjb9's avatar
sjb9
New Member
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ，

     

    Thanks for sharing the solution!