Forum Discussion
Kept getting error (missing credentials) to connect Power BI Service to Azure Databricks
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).
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.
3 Replies
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.
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.
Hi, @lcc6
I met this problem too, did you solve it and how?
Look forward to your reply.
Thanks.
Kind Regards,
Jin