Forum Discussion
How to connect Teams with Power BI
I would like to know how I can connect Teams(Shift) with Power BI.
Could someone share a step by step?
Thanks
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
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.
3 Replies
- jennratten
Super User
Are you trying to use Power BI to connect to files within Teams?
I'm trying to use Power Bi to connect to Teams Shifts.
- v-angzheng-msft
Community Support
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
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.
