How to connect Teams with Power BI

[allan_oliveira]

I would like to know how I can connect Teams(Shift) with Power BI.
Could someone share a step by step?

Thanks

[v-angzheng-msft · Accepted solution]

Hi, @allan_oliveira 

To use an OData feed to directly query the Graph  API directly into PowerBi.  The data is then updated when the report is refreshed.

= OData.Feed("https://graph.microsoft.com/beta/teams/your teams ID #/schedule", null, [Implementation="2.0"])

More related information:

https://community.powerbi.com/t5/Desktop/Get-data-from-Microsoft-teams-shifts/td-p/807676

https://docs.microsoft.com/en-us/graph/api/schedule-list-shifts?view=graph-rest-beta&tabs=http

https://powerusers.microsoft.com/t5/Building-Power-Apps/Shifts-for-microsoft-Team-in-PowerApps/td-p/...

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten]

Are you trying to use Power BI to connect to files within Teams?

[allan_oliveira]

I'm trying to use Power Bi to connect to Teams Shifts.