Issue with Data Refresh in Power BI Service - Token Expiry Error

[notsobad__]

Hi everyone,

I’ve run into an issue with refreshing my Power BI dataset in the Power BI Service, and I’m hoping someone can help me out. Here’s the situation:

I’ve created a report in Power BI Desktop that combines Usage Metrics from multiple workspaces. I’m using the Analysis Services connector to pull in the Page Views and Reports Views tables in Import mode. Everything works perfectly in Power BI Desktop—the data refreshes without any issues, and I can combine data from all workspaces seamlessly.

However, when I try to refresh the same dataset in the Power BI Service, I keep running into the following error:

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-10-29T11:43:19.6991784Z and was inactive for 90.00:00:00. Trace ID: f0f95692-fa1c-428b-a10f-99031071b800 Correlation ID: 29513231-bf2b-4cc3-a723-e1e2bc397be9 Timestamp: 2025-02-12 08:47:29Z"}}],"exceptionCulprit":1}}} Table: TableName.

The error indicates that the refresh token has expired due to inactivity. Interestingly, I don’t face this issue when refreshing the data locally in Power BI Desktop. It only happens in the Power BI Service.

Has anyone encountered this issue before? If so, how did you resolve it? I’m looking for any suggestions or solutions to get this working in the Power BI Service.

[v-tsaipranay · Accepted solution]

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.

[v-tsaipranay]

Hi @notsobad__  ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @notsobad__ ,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-tsaipranay]

Hi @notsobad__ ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[SamInogic]

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:

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.

2. 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.

3. Remove and Reconnect the Dataset

• If the issue persists, try removing the dataset from Power BI Service and republishing it from Power BI Desktop.

4. 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.

5. Try a Personal Gateway (If Applicable)

• If you're using a Personal Mode gateway, restarting or reinstalling it might help.
  
  

Thanks!

[notsobad__]

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.