How to connect Teams with Power BI

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/930921

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.