Forum Discussion
DMTS_OAuthTokenRefreshFailedError - The refresh token has expired due to inactivity
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.
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.
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
2 Replies
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.
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