Connectivity between PBI and Databricks using Service Principle or App Id

[Vaishali04]

Hi All,

I want to connect Power BI to Azure Databricks either using service principle or Application ID. If anyone has done it please share the steps.

Thanks 

Vaishali

[v-jingzhang]

Hi @Vaishali04 

It seems the built-in Azure Databricks connector doesn't support using service principle for credentials. I found a blog about setting up service principal for Azure Data Lake. Not sure it would be helpful or not. Here is the link: Power BI Setting up a Service Principal for Azure Data Lake Gen 2 (Storage) to use with Data Factor ...

Best Regards,
Community Support Team _ Jing

[NoorBashaShaik]

Spoiler

Hello

​What is the best practice here -

1. To develop the reports by connecting to Databricks using individual PATs.

2. Then, after deploying the report to PowerBI service, change the data source credentials to point to the PAT of the Service Principal so data import is done based on defined schedule.

3. PowerBI report users then need not be having Databricks accounts as the underlying service principal is fetching data for them.

Is my understanding correct?