Query all shift data from Teams/Shifts to analyze in Power BI

[wmgemmell]

Greetings, Community.

I know this may be a question for another location but I am ultimately working with Power BI so I thought I would try here, too.

I am working on trying to query all available shift data from various Teams.  I have been successful with the below but it only provides my personal shift data from a test team I have set up and will not provide the data for the other two test members within that team.  I've tried searching for ways of doing this but haven't found anything useful as of yet.  Any thoughts or points of direction are greatly appreciated.

GET https://graph.microsoft.com/v1.0/teams/{TeamID}/schedule/shifts Used beta as well

Permissions:  Group.Read.All & Group.ReadWrite.All\

Currently, I am researching the use of Azure AD and the console to call Graphs for this task.  At least it looks like this might be the path that needs followed.  I am reading up on this now but if anyone has any advice or better direction, that, too, is appreciated.

Thank you in advance for your help.

Wm

[wmgemmell · Accepted solution]

As an update, I was able to solve this using the Graph Explorer v1.0 with the following ODATA query:

= OData.Feed("https://graph.microsoft.com/v1.0/teams/"[Team ID]"/schedule", null, [Implementation="2.0"])

[v-deddai1-msft]

Hi @wmgemmell ,

Would you please refer to the similar post:https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006?

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

Best Regards,

Dedmon Dai

[wmgemmell]

Hi, @v-deddai1-msft.

Thank you for your reply.  I do not see this as the solution.  I am not having any trouble pulling the data into Power BI, it is more what query is needed in Graphs that will query all Teams members Shifts data.  Right now, my query only provides my personal shift data, not everyone elses.  Pulling the data into Power BI is straight forward though using the ODATA feed.

Wm