Connecting Power BI to aws databricks using service principal

FaizH
New Contributor III

‎07-12-2024 01:08 PM

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

FaizH_0-1720813920178.png

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

FaizH_1-1720814138258.png

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

FaizH_2-1720814351495.png

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

FaizH_5-1720814797997.png

 

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

FaizH_4-1720814710478.png

Does any one where I am going wrong?

 

 

 

 

 

0 Kudos

iakshaykr
New Contributor III

‎07-14-2024 06:32 AM

@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. )

FaizH
New Contributor III

‎07-15-2024 01:54 AM

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.

View solution in original post