topic Re: Connecting Power BI to aws databricks using service principal in Get Started Discussions

Connecting Power BI to aws databricks using service principal

FaizH — Fri, 12 Jul 2024 20:08:25 GMT

Hi,

I am trying to connect AWS Databricks to PowerBI using service principal. Below are the steps I followed:

1. Created Service Principal in Identity and Access

2. I went to Permission setting page under Settings>Advanced and added this new service principal with below permission.

3. I connected to Databricks using PAT and generated token value:

4. I went to the Catalog page and granted permission to this new service principal account

5. I added the generated token value in step 3 to Power BI report under edit credentials and I got this error.

Does any one where I am going wrong?

Re: Connecting Power BI to aws databricks using service principal

iakshaykr — Sun, 14 Jul 2024 13:32:01 GMT

@FaizH -

Try this : https://docs.databricks.com/en/partners/bi/power-bi.html and also explore this https://docs.databricks.com/en/integrations/compute-details.html make sure you are usign correct Authentication method .

NOTE : Also may be your SPN is not create in Azure AD ( Databricks (Beta), if you authenticate using OAuth. )

Re: Connecting Power BI to aws databricks using service principal

FaizH — Mon, 15 Jul 2024 08:54:16 GMT

Thanks for the reply, I got the solution. I was missing adding SP account in SQL Warehouse permission setting. After adding it, my PBI report is working fine.