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-...
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