Power BI Service refresh failures caused by intermittent Databricks credential invalidation

luiz_felipe
New Contributor

Hi everyone,

We are experiencing an intermittent issue in Power BI Service where datasets and dataflows connected directly to Databricks start failing refreshes because the credentials appear to be lost or invalidated, even though no manual changes were made.

Scenario:

  • Direct connection from Power BI Service to Databricks (no gateway involved)
  • Databricks SQL Warehouse (Serverless) is being used
  • Authentication using either OAuth or a Databricks personal access token
  • Everything works fine for a period of time, then refreshes suddenly fail asking for credentials again
  • After re-entering and saving the credentials, the refresh works normally again

The connection is made using the DatabricksMultiCloud.Catalogs connector, pointing to a specific catalog.

Error message:

  • Data source error: Retry attempts for failures while executing the refresh exceeded the retry limit
  • Error code: DMTS_OAuthTokenRefreshFailedError
  • Underlying error: OAuth token refresh failed while requesting a Databricks OIDC token
  • HTTP status: 400 (Bad Request)

My question:

  • Has anyone experienced this kind of intermittent credential loss between Power BI Service and Databricks when using SQL Warehouse Serverless?
  • Are there any known limitations, recommended configurations, or best practices to prevent credentials from expiring or being invalidated automatically in this setup?

The goal is to understand the root cause and avoid having to manually reauthenticate every time the issue occurs.

Thanks in advance!