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 correct token (making sure it's correct), an error will be reported as shown in the figure.

 

This is very strange and i don't know how to solve it. I tried to have another colleague take over the data cource and then it connected successfully.

 

What should i do? Please help me, thanks! 

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.

6 Replies

  • oussamahaimoud's avatar
    oussamahaimoud
    Memorable Member
    3 months ago

    Hi Leo7,

     

    The fact that it worked for your colleague confirms the connection pathway and cluster are fine,the problem is squarely with your user account's token/permissions in Databricks.

     

    The status code 400 with "Key" authentication almost always means the token itself is being rejected by Databricks, even if it looks correct to you. Common reasons:

    • Your token was revoked
    • Your account lost permissions
  • Lodha_Jaydeep's avatar
    Lodha_Jaydeep
    Solution Sage
    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..

      • oussamahaimoud's avatar
        oussamahaimoud
        Memorable Member
        3 months ago

        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