Forum Discussion

Leo7's avatar
Leo7
Frequent Visitor
3 months ago
Solved

Failed to update data source credentials in PowerBI Service

Hi everyone,   All my PowerBI connections (mainly connect to databricks) suddenly crashed, with prompt indication that the connection could not be tested. If i try to edit and input the corr...
Need Help
  • Lodha_Jaydeep's avatar
    Lodha_Jaydeep
    3 months ago

    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.

Leo7's avatar
Leo7
Frequent Visitor
3 months ago

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

v-tejrama's avatar
v-tejrama
Community Support
3 months ago

Hi Leo7 ,

 

Thank you Lodha_Jaydeep and oussamahaimoud  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.