Power BI - Databricks Integration using Service Principal

[venkat-bodempud]

Hello Community,

We are able to connect to databricks(using Personal access token) from Power BI Desktop and we able to set up scheduling databricks notebook using DataFactory for every 10 minutes(as per our requirement). 

We want to avoid using the personal access token. What are all the alternatives and how service principal helps here?

Objective: We want avoid individual user credentials in the system.

I request the community the help us here.

Thanks

Venkat

[venkat-bodempud]

Thank you community for all your answers.

Another question:

How to schedule refresh using service principal?

I mean when we add datasource to the data gateway,

what is correct authentication type i should choose? 

is it basic? or key or oauth?

when i chose basic authentication for service principal, what would be the username and password?

what is the Key?

i know that OAuth is Office 365 authentication.

Please share your answers.

Thanks

Venkat

[RicoZhou2]

Hi @venkat-bodempud ,

Refering from Offical Blog: Connect to Power BI - Azure Databricks | Microsoft Docs

As a security best practice, when authenticating with automated tools, systems, scripts, and apps, Databricks recommends you use access tokens belonging to service principals instead of workspace users.

For more information, see Service principals for Azure Databricks automation.

Best Regards.

[amitchandak]

@venkat-bodempud , Refer if this can help

https://docs.microsoft.com/en-us/azure/databricks/administration-guide/users-groups/service-principa...