Forum Discussion
Issue with Data Refresh in Power BI Service - Token Expiry Error
Hi notsobad__ ,
Thanks for reaching out to the Microsoft fabric community forum.
In Power BI Desktop, you interact directly with the data source, bypassing the token expiration policies that apply to Power BI Service. When you refresh data locally, you authenticate directly with the data source, avoiding token expiration issues.
Power BI Service, being cloud-based, handles authentication and tokens differently. The service requires regular token usage to keep sessions active. Periods of inactivity cause token expiration, leading to errors when refreshing data in the cloud.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi,
As per our understanding this issue happens 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:
- 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.
- 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.
- Remove and Reconnect the Dataset
- If the issue persists, try removing the dataset from Power BI Service and republishing it from Power BI Desktop.
- 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.
- Try a Personal Gateway (If Applicable)
- If you're using a Personal Mode gateway, restarting or reinstalling it might help.
Thanks!
Please do not post this chat-gpt like answers. The usage metrics are refreshing normally. This error happens when trying to refresh semantic model that is taking the data thorugh aas connector in the pbi service, locally everythink works.