Kept getting error (missing credentials) to connect Power BI Service to Azure Databricks

[Anonymous]

I have some issues with the connectivity from Databricks to Power BI service. After I have published my app to Power BI service, I would like to schedule a refresh with the data. However I found that an error pop up (missing credentials) in Power BI Service. The connection with Azure Databricks was lost in Power BI service.

When I tried to edit the credentials to reconnect with it, I kept getting the 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.".

There are three options for me to connect: Basic, Key and OAuth2. I tried with OAuth2 by signing in my account and it didn't work. It doesn't happen in Power BI Desktop where I obtained my credential with Azure Active Directory (the same account).

[PBIUserJin]

Hi, @lcc6 

I met this problem too, did you solve it and how?

Look forward to your reply.

Thanks.

Kind Regards,

Jin

[v-zhangti · Accepted solution]

Hi, @Anonymous 

For reference:

Connect to Power BI - Azure Databricks | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

[v-zhangti]

Hi, @Anonymous 

The server name and database name entered when adding a data source should be the same as those entered in Desktop, but the authentication method can be different: for example, you can use The Windows authentication method, the Basic authentication method can log in to SQL Server, usually using Windows.

You also need to install a data gateway to refresh the datasets on the service. 

For reference:

What is an on-premises data gateway? | Microsoft Docs

On-premises data gateway in-depth - Power BI | Microsoft Docs

Manage your data source - Analysis Services - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Charlotte

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