Forum Discussion
Connectivity between PBI and Databricks using Service Principle or App Id
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
2 Replies
Hi Anonymous
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 | Peak Indicators
Best Regards,
Community Support Team _ Jing- 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?
