Forum Discussion

Mrignalini's avatar
Mrignalini
Frequent Visitor
1 year ago

Error while trying to refresh data in power bi app

I am trying to refresh the data in power bi app. The data source is of Azure databricks. I am getting below error.

  • usually i would get an authentication code after i click "sign in" but it not happening it is just showing me this error.

2 Replies

  • Hi Mrignalini 

     

    I would recommend chatting to your data bricks administrator to ensure that you can connect to the database, plus the using oAuth authentication with the account you have provided.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,GilbertQ ,thanks for your concern about this issue.

    Your answer is excellent!
    And I would like to share some additional solutions below.

    Hello,Mrignalini .I am glad to help you.

    It looks like you are experiencing authentication issues when trying to refresh your data in Power BI!
    Hopefully the following suggestions will help you


    Check your SSL certificate: make sure that the SSL certificate for Azure Databricks is properly configured and that the connection is over HTTPS. This is necessary when using OAuth 2.0 authentication.
    Check the flow of OAuth 2.0 authentication: Please make sure that you have performed all the steps correctly, including obtaining and entering the authentication code. If you do not receive the authentication code, you may need to log in again or check your Azure Databricks settings.
    To rule out caching effects, please log back into your account after clearing your browser, refresh your data source credentials, and make sure there are no expired or invalid tokens.

    I have found some articles related to configuring SSL certificates in Power BI that I hope you find helpful.

    URL:
    SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI
     

    URL:
    OAuth 2.0 - Overview
    Solved: Data Source Credential error upon using OAuth 2.0 ... - Microsoft Fabric Community
     


    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.