Connectivity between PBI and Databricks using Serv...

Vaishali04 · ‎01-30-2022

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 · ‎02-02-2022

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

Anonymous · ‎11-18-2022

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?

HelloWhat 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?