The refresh token has expired due to inactivity

by ·Comments Off on The refresh token has expired due to inactivity

Product:

Microsoft Power BI service
Issue:

When click on refresh for a dataset (sematic model) in https://app.powerbi.com/ you get a error like:

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 2024-11-19T10:55:36.9381120Z and was inactive for 90.00:00:00.

Solution:

Wait and try again later or go into your PowerBI report and update all credentials to different data sources you have used in your report.

In the dataset – go to settings – take over as owner –  go to data source credentials

click on edit the credentials and update with your account information. This should refresh the token.

This issue can happen when the OAuth refresh token used by Power BI Service to authenticate with the data source has expired. The error message shows that your token has been inactive for 90 days, which is the default expiration period for Azure Active Directory (AAD) refresh tokens.

Here are a few suggestions you can check:

  1. Re-authenticate the Data Source in Power BI Service
  • Go to Power BI Service (app.powerbi.com).
  • Navigate to Settings > Manage Connections and Gateways.
  • Locate the data source for your dataset.
  • Click Edit Credentials and sign in again using your credentials.
  • Choose the correct authentication method (usually OAuth2 for Analysis Services).
  • Save and retry the refresh.
  1. Check and Update Permissions
  • If your credentials were updated or your permissions changed, you may need to reassign them.
  • Ensure that your account has read permissions on the Analysis Services data source.
  • If your organization uses Conditional Access Policies, check with your IT team to ensure Power BI can maintain an active connection.
  1. Remove and Reconnect the Dataset
  • If the issue persists, try removing the dataset from Power BI Service and republishing it from Power BI Desktop.
  1. Ensure Your Token Doesn’t Expire Again
  • If you’re using service accounts, consider setting up a refresh schedule to keep the token active.
  • Work with your IT admin to adjust AAD token lifetime policies to extend the refresh token validity.
  1. Try a Personal Gateway (If Applicable)
  • If you’re using a Personal Mode gateway, restarting or reinstalling it might help.

 

More Information:

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios 

https://www.c-sharpcorner.com/article/how-to-handle-power-bi-data-refresh-error-refresh-token-expired/

https://www.vuepilot.com/support/article/microsoft-power-bi-authentication-information/ 

https://www.beringer.net/beringerblog/power-automate-connection-reference-failures/