Connecting Power BI to aws databricks using service principal

[FaizH]

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?

[iakshaykr]

@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 · Accepted solution]

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.