The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
My PBI dashboard is connecting to a Databricks data source.
I got below error about every 10 days when refreshing a model from a daily schedule. I have to reset the Data source credentials to solve the issue.
I use OAuth2 and privacy level set to 'Organizational' when setting the Data source credentials.
I am not sure why the issue happens every 10 days?
The error
Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[DataSource.Error] Web.Contents failed to get contents from 'https://tfs-edp.cloud.databricks.com/oidc/v1/token' (400): Bad Request"}}],"exceptionCulprit":1}}} Table: rz_databricks_jobs_not_run_pre_7_days.
Tokens do expire. Updating your credentials should be part of your regular maintenance.
Every 10 days is a bith harsh though - can you ask your Databricks admin for an option to extend that a bit? To the "standard" 90 days, for example?
I ended up using key (Databricks token) to connect. That expires in 90 days hopefully.