Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Connectivity issue from Power BI to Azure DataBricks

Hi Team,

We are importing data from Azure databricks to PBI and published it into PBI Service Premium Workspace. 
The data refresh from PBI desktop working fine .However when we try to schedule refresh from Workspace getting the following Authorisation error : 

Failed to update data source credentials: [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Unauthorized/Forbidden error response returned, but no token expired message received

We are authorizing using Azure AD credentials in both from PBI desktop and PBI Service. In desktop it is working fine and getting latest data from DataBricks but from PBI service it is throwing the above mentioned error

Attaching the error Screenshot


We use OAuth method for authentication. Which gives above shown error from Service but works fine from PBI Desktop

 



Any idea how to fix the issue? If this is some access Restriction then why it works from PBI Desktop but not from Service?

Regards
Michel

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Anonymous 

     

    I would suggest looking at your connectivity to your databricks system. Maybe there is a firewall issue which is stopping the service from connecting to your databricks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

     

    Check the credentials in the data source settings.Make sure that the Azure AD account you entered has permissions for the data source. You can check out the following documents：

     

    Solved: connection with databricks failing - Microsoft Fabric Community

     

    Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn


    Review OAuth token expiration and renewal settings. If the token is about to expire and is not properly renewed, it can lead to an authorization error. You can check out the following documents：

     

    Troubleshoot Power BI REST APIs - Power BI | Microsoft Learn


    Check the assigned permissions and roles in Azure. Make sure that the Power BI service has the required permissions to access Azure Databricks. 


    Check that the Databricks server is up and running and accessible from the network. Or, as GilbertQ says, check to see if your firewall is blocking Databricks connections.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.