This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
I'm working with the MyGraph power query sample and I've been able to pull data when I define my source like this:
source = OData.Feed("https://graph.microsoft.com/v1.0/me/", null, ...
source = OData.Feed("https://graph.microsoft.com/v1.0/users", null, ...
but when I change the URL to "https://graph.microsoft.com/v1.0/users/af23248a-fbf4-4ec9.../planner/tasks" I get an error saying "The credentials provided for the MyGraph source are invalid. (Source at MyGraph.)"
I have tested the URL on Graph Explorer https://developer.microsoft.com/graph/graph-explorer/ and I get a response with all the tasks for this user.
I thought it might the API permission for this app so I added all the User and Tasks permissions for Microsoft Graph in the Azure Portal. I've also added additional scopes for User and Task in the MyGraph.pq file, but I still get the error.
`scope_prefix = "https://graph.microsoft.com/";
scopes = {
"User.Export.All",
"User.Invite.All",
"User.Read",
"User.Read.All",
"User.ReadBasic.All",
"User.ReadWrite",
"User.ReadWrite.All",
"Tasks.Read",
"Tasks.Read.Shared",
"Tasks.ReadWrite",
"Tasks.ReadWrite.Shared",
`
What am I doing wrong?? Please help!
@martha ,
Currently, it is not possible to get data from planner task in Power BI Desktop, there is an idea about this issue, please vote it up.
There is also a similar thread for your reference.
https://community.powerbi.com/t5/Service/Is-it-possible-to-get-the-planner-task-from-Microsoft-Graph...
Regards,
Lydia
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.