Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Use a Service Principal to deploy a PowerBI report against Databricks OAuth with Direct Query

I am using a Service Principal to deploy a PowerBI report with a DirectQuery dataset connected to a Databricks SQL endpoint. This is in a deployment pipeline. When the report is run, I want it to pas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have tried that, it doesn't work (or at least I couldn't construct a message that would work).

 

When comparing the working dataset (deployed with a user account) and the broken one pre-takeover (deployed with a service principal), the differences are the CredentialType and CredentialDetails\useEndUserOAuth2Credentials properties. When I try and patch them in I get a PowerShell error:

 

Tracing the error using Fiddler shows this error body (note that no type is mentioned):

"{"error":{"code":"InvalidRequest","message":"Property useEndUserOAuth2Credentials is only supported with credentials of type and datasource type of Extension"}}"

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello

    Did you set-up oauth app additionally? Or is it not required? Was the service principal issue resolved?