Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wmgemmell
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
wmgemmell
Frequent Visitor

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"])

View solution in original post

3 REPLIES 3
wmgemmell
Frequent Visitor

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
Community Support
Community Support

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

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors