Forum Discussion

jmoreyproadata's avatar
jmoreyproadata
New Member
6 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"])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 

pmahawar's avatar
pmahawar
New Member
2 years ago

Hi, I am able to access all other tables except time card. I get an 'access forbidden error'. Would you mind telling what permission levels did you set in your Azure to read the time card data?