topic Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse in Data Engineering

How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

pgruetter — Mon, 27 Mar 2023 17:19:58 GMT

Hi all

I'm struggling to connect PowerBI service to a Databricks SQL Warehouse using a service principal.

I'm following mostly this guide.

I created a new app registration in the AAD and created a client secret for it.

Now I'm particularly struggling with the second step of adding the service principal to the Databricks account.

If I open the link accounts.azuredatabricks.net, I can select the correct workspace after authentication, but this only brings me to the welcome page of the Databricks workspace.

I can't find the "User management" page that is mentioned.

--> Where / how can I add the service principal to Databricks ?

Thanks for any help

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

Anonymous — Sun, 02 Apr 2023 13:57:56 GMT

@pgruetter :

To add a service principal to Databricks, you need to follow the steps below:

Go to the Azure Databricks portal and navigate to the "Workspace" section.
In the left pane, click on "User Management" and then select "Credentials" from the drop-down menu.
Click on the "Add" button and select "Service Principal".
Enter the client ID and client secret that you created in Azure AD when you registered your app.
Select the appropriate Azure Databricks workspace and click "Create".

After following these steps, you should be able to connect Power BI service to Databricks SQL Warehouse using the service principal.

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

pgruetter — Tue, 04 Apr 2023 06:08:12 GMT

Thanks for the feedback. My problem is, that I don't have a "User Management" in the left pane.

In the meantime, I found the reason for that: The description only works if you're using Unity Catalog. In this case, we don't use Unity Catalog yet.

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

Anonymous — Tue, 04 Apr 2023 06:23:12 GMT

Hi @pgruetter

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

pgruetter — Tue, 04 Apr 2023 07:21:37 GMT

I couldn't completely solve this issue yet. But I think I managed to add the service principal to the classical Databricks Workspace by going to the Admin Console --> Groups --> edit "admins" group.

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

pgruetter — Wed, 12 Apr 2023 07:18:51 GMT

In the end, once the Service Principal is properly authorized on the Databricks side, I had to create a Personal Access Token for the Service Principal using the Databricks API.

On the Power BI service side I then had to use username = 'token' and as password the generated PAT.

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

amiebarkes — Wed, 01 Nov 2023 13:49:47 GMT

Hello

I was wondering if you could elaborate on the solution to the issue you posted. We have a Power BI dataset based upon tables in a databricks sql warehouse. I have followed the steps to create an access token for the service principal which is registered in the databricks workspace with admin permissions. However when changing the credentials for the power bi data source we specified authentication method = Username/Password and entered the word Token in the username field and the PAT token generated on behalf of the service principal.

This resulted in an error

I was wondering if we had correctly followed your procedure?

Kind regards

Amie

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

AmanSehgal — Mon, 25 Mar 2024 03:20:29 GMT

Please check if you have enabled the service principal to use PAT token in admin settings.

Re: How to use Service Principal to connect PowerBI to Databrick SQL Warehouse

Lone — Mon, 21 Jul 2025 14:56:28 GMT

Hello All,

After successfully adding a service principal to Databricks and generating a client ID and client secret, I plan to utilize these credentials for authentication when configuring Databricks as a data source in Power BI. Could you please clarify whether the client ID and client secret generated in Databricks for the service principal have an expiration date or remain valid indefinitely? I would greatly appreciate insights from anyone who has completed this process.

Thank you for your assistance.