Connect to Teams "SHIFTS" App Data

[Robert14358]

Hello Everyone.

Does anyone know of a connector to bring in Teams Shifts App Calendar Data into Power BI?

Thank you.

[Robert14358]

is microsoft going to make a connector for Teams Shifts?

[ChrisMendoza · Accepted solution]

There already is in Logic Apps, Power Apps, Power Automate Shifts for Microsoft Teams - Connectors | Microsoft Docs; unfortunately not Power BI.

[Robert14358]

ok i got i to work in the graph 1.0 website, but how does this work in Power BI?

[ChrisMendoza]

So, funny enough I can't get it to work in the Graph Explorer:

{
    "error": {
        "code": "NotFound",
        "message": "{\"error\":{\"code\":\"NotFound\",\"message\":\"Sorry, the team was not found, or you may not have access to it.\",\"details\":[],\"innererror\":{\"code\":\"TeamNotFound\"}}}",
        "innerError": {
            "date": "2022-07-07T18:48:22",
            "request-id": "04ec2fa7-50e2-42b5-bd53-59f4c93140c5",
            "client-request-id": "b9f30f12-2cd1-dbfb-3f06-9cf7776e0487"
        }
    }
}

However, I'm pretty sure that you would need to Get data > OData feed in Power BI Desktop.

Then in the Power Query Editor you'd do your navigation/transformations.

Unfortunately, I have the error and cannot test for you.

[Robert14358]

I tried that but it says the URL is invaild, what ID is the teams ID?

[ChrisMendoza]

One way is to 'Get link to team' then look at the URL for ?groupId= all the way up to '&tenantId'

[ChrisMendoza]

Did you try https://community.powerbi.com/t5/Desktop/Query-all-shift-data-from-Teams-Shifts-to-analyze-in-Power-... ?