Forum Discussion
Resfesh Issues (DMTS_OAuthTokenRefreshFailedError)
Hi koralka,
Thanks for reaching fabric community, will happy to assist.This looks related to the stored OAuth credential/token used by Power BI Service for the Databricks source. Edit credentials will fix this issue temporarily.
Can you answer the questions below?
- Recreate the Databricks data source credentials in the semantic model settings.
- Confirm whether the connection uses a personal user OAuth login or a service principal.
- Check if Conditional Access, MFA/session policies, or token lifetime policies changed.
- Confirm the Databricks SQL warehouse/cluster is available during scheduled refresh.
- Make sure all queries use the same Databricks server/HTTP path, so Power BI does not store multiple credentials for similar sources.
Service principal authentication for Power BI and Databricks:
https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi-m2mPower BI refresh troubleshooting steps:
https://learn.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenariosPLease consider this as an accepted solution if it helps or give it some kudos.
Thanks,Here I am attaching some microsoft documentations, you can have a look to get the information. Can you allowed to update the connection to use service principal instead OAuth?
https://learn.microsoft.com/en-us/entra/identity/monitoring-health/how-to-view-applied-conditional-access-policies
https://learn.microsoft.com/en-us/entra/identity/conditional-access/troubleshoot-conditional-access
https://learn.microsoft.com/en-us/entra/identity-platform/configurable-token-lifetimesNote: I used AI only to help paraphrase this response.
Hello,
Thank you for those, I will have a look. In terms of changing to service principal - how would I do that? Would I need to create a new connection under 'Manage Connections and Gateways'?
I'm not sure how that works. When I go to Settings -> Data Source Credentials -> Edit Credentials, I only have the following options as Authentication methods: OAuth2, Key, Basic.
Thank you for your help
Hi koralka,
Your answer is in my 1st post. Please go through the documenataion for the service princiapal authentication.
Hi koralka ,
Thank you for reaching out to the Microsoft Community Forum. could you please try the proposed solution shared by Lodha_Jaydeep ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Hi koralka ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hello, yes, apologies. The first response should be now accepted as a solution.
Regards
Karolina
