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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Data Source Connection to Microsoft Graph API Error - Data Refresh Failed

Sarunyu_0-1679377794339.png

Sarunyu_0-1679378489734.png

Data source error: The credentials provided for the Web source are invalid. (Source at https://graph.microsoft.com/v1.0/reports/getOffice365ActiveUserCounts(period='D7').). The exception was raised by the IDbCommand interface. Table: Office365_Schools_activeUsers.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: fbd5215a-b406-4ea7-881e-bf22686d284a
Request ID: d7107bbd-85eb-760b-62d8-cec68e78f99c
Time: 2023-03-21 04:51:10Z

 

We use the access token connecting to Microsoft Graph API. We set Data Source credential as anonymous. The data model has been able to refresh fine until today at 6am

 

 

Status: Needs Info

Hi @Sarunyu 

Is there a possibility that your token has expired? Maybe you can retrieve a token and update the Service's credentials ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @Sarunyu 

Is there a possibility that your token has expired? Maybe you can retrieve a token and update the Service's credentials ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Sarunyu
Regular Visitor

Hi  Alisa@v-yetao1-msft ,


Thank you for looking into it. 
In the power query; It generates a new token every time it makes API calls. 

There's no code changes since the issue occured. 

I disabled the data refresh on 21/3/23 and have just tried refresh the data model again today 27/3/23 and it seems the issue has recified itself.
Could this be the issue on the Microsoft Graph API side? 

Sarunyu_1-1679875213164.png