cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
martha Occasional Visitor
Occasional Visitor

Custom Data Connector: MyGraph Sample => The credentials provided for the MyGraph source are invalid

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

 

 

error2.JPG

 

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!

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Custom Data Connector: MyGraph Sample => The credentials provided for the MyGraph source are

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.