Forum Discussion
Failed to update data source credentials in PowerBI Service
Hi Leo7,
Thanks for reaching. Adding some more details to oussamahaimoud's reply.As the same is working with take over by the another user. It's most probably the token rejected while requesting the databricks althogh it looks correct to you.
Can you try,
- Clear/Remove the Data Source settings and re-enter the connection detail and sign-in again.
Steps: File → Options and settings → Data source settings or by as shown below.
Please consider as an accpeted solution if it helps or give some kudos.
Hi Lodha_Jaydeep and oussamahaimoud ,
Thanks for both replies. In fact, I have attempted to clear all credentials. On the pbi desktop, I can successfully connect to Databricks and refresh data, but on the server, I am unable to create a new connection (using the same databricks cluster and personal access token).
It seems that I don't have permission to the datasource, but my group and permissions in Databricks haven't changed..
Power BI Desktop stores credentials locally on your machine. The Service manages credentials separately per-user per-dataset. Clearing credentials and trying to re-add them via the Connections panel uses a different (unsupported) path for this connector type.
The credential must be set directly on the semantic model settings page, not from the global connections manager.
So, don't create a new connection from the connections panel. Instead:
Go to your Workspace in Power BI Service
Find your Semantic Model (dataset)
Click the three dots (...) → Settings
Scroll to Data source credentials
Click Edit credentials next to the Databricks source
Enter Authentication method: Key, paste your PAT, set Privacy to Organizational
Click Sign in