DMTS_OAuthTokenRefreshFailedError - The refresh token has expired due to inactivity

[RewindsTime]

Receiving this error. The data source is an on-premises SQL server, through a gateway.

Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2023-12-03T20:02:46.0084532Z and was inactive for 90.00:00:00. Trace ID: dbccd607-e59b-493d-89d8-b3bdc3286400 Correlation ID: 3b153b60-68a1-4cff-ae0b-5c9be721dd5c Timestamp: 2024-04-08 00:34:24Z"}}],"exceptionCulprit":1}}} Table: <NameRemoved>.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 336e0e23-5583-448e-903e-1d10b1594e7f
Request ID: 104b81ab-f70d-bfdf-3104-1ea7eb87eb8b
Time: 2024-04-08 00:34:24Z

Currently using a data gateway to connect to the on-premises server.

[Anonymous · Accepted solution]

Hi @RewindsTime ,

It seems that you may face DMTS_OAuthTokenRefreshFailedError, it means that the OAuth refresh token used for authentication with the on-premises SQL server through the gateway has expired due to inactivity. The refresh token typically expires if it hasn’t been used for a certain period, which appears to be 90 days in this case.

I think you can go to the dataset settings in your Power BI service. Navigate to the data source settings. Update the credentials for your on-premises SQL server. This should prompt you to sign in again and refresh the authentication token.

Also I think you can read this topic: Solved: Powerbi refresh issue with DMTS_OAuthTokenRefreshF... - Microsoft Fabric Community and Solved: DMTS_OAuthTokenRefreshFailedError - Microsoft Fabric Community

Best Regards

Yilong Zhou

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

[Anonymous · Accepted solution]

Hi @RewindsTime ,

Have you solved your problem? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Yilong Zhou

[Anonymous · Accepted solution]

Hi @RewindsTime ,

It seems that you may face DMTS_OAuthTokenRefreshFailedError, it means that the OAuth refresh token used for authentication with the on-premises SQL server through the gateway has expired due to inactivity. The refresh token typically expires if it hasn’t been used for a certain period, which appears to be 90 days in this case.

I think you can go to the dataset settings in your Power BI service. Navigate to the data source settings. Update the credentials for your on-premises SQL server. This should prompt you to sign in again and refresh the authentication token.

Also I think you can read this topic: Solved: Powerbi refresh issue with DMTS_OAuthTokenRefreshF... - Microsoft Fabric Community and Solved: DMTS_OAuthTokenRefreshFailedError - Microsoft Fabric Community

Best Regards

Yilong Zhou

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