topic Re: Connecting with Azure AD token in PowerBI in Data Engineering

Connecting with Azure AD token in PowerBI

KaushikMaji — Mon, 21 Feb 2022 08:12:52 GMT

Hello,

We are trying to connect Databricks SQL endpoint from PowerBi using Azure AD service principal, which has been added to Databricks workspace using SCIM APIs. Now, when we open connection to Databricks in powerbi desktop and provide Azure AD access token (as mentioned in link below), we get error saying "We couldn't authenticate with the credentials provided. Please try again." (screenshot below).

https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#---connect-with-power-bi-desktop-by-using-partner-connect

Ultimate goal is to use Service Principal credentials instead of individual credentials, when we publish the dataset to power bi service and we hope Powerbi service will manage the oAuth2 flow to get the token.

May you please suggest what is possible?

I have managed to get a PAT for the Service Principal that is added to workspace, using the SCIM APIs. But, I don't want to use PAT as it is static and if anyone gets hold of it, they can easily get into the data.

Thanks and Regards,

Kaushik Maji

Re: Connecting with Azure AD token in PowerBI

-werners- — Mon, 21 Feb 2022 09:55:08 GMT

At the moment I do not think that is possible.

The help page mentions:

An Azure Active Directory token (recommended), an Azure Databricks personal access token, or your Azure Active Directory account credentials.

These methods are all user bound, so no service principal.

What we do is using a '*****' user which has access to Databricks and powerbi.

Re: Connecting with Azure AD token in PowerBI

KaushikMaji — Mon, 21 Feb 2022 18:51:42 GMT

Thanks for your reply. I didnt get your last point. What user? its masked in your reponse

Re: Connecting with Azure AD token in PowerBI

-werners- — Tue, 22 Feb 2022 07:21:38 GMT

Hm redacted...

Yea we just use a default userID which is only used for powerBi connectivity

Re: Connecting with Azure AD token in PowerBI

venkat-bodempud — Wed, 24 Aug 2022 16:06:00 GMT

@Kaushik Maji

Hi Kaushik,

I am currently working implementing similar to this thread. I need your help here as you already have exposure around the same.

connecting to azure data bricks using service principal.
use service principal based authentication for configuring azure data bricks data source in power bi service.
what is the authentication type we should use?
what would be the username and password should be used in Power BI Service .

I request you to help me. I am happy to provide you more information if required.

Thanks

Venkat