Forum Discussion

danjo914's avatar
danjo914
Frequent Visitor
1 year ago

ASAZURE to Fabric Warehouse SQL Endpoint

What we are trying to do is to set up an ASAZURE model to pull from a warehouse via sqlendpoint from a Microsoft Fabric Workspace. This works fine if I use my own Microsoft Credentials, however, the ...
data engineering
danjo914's avatar
danjo914
Frequent Visitor
1 year ago

Hi Xiaoxin,

Thank you for your response. My question is specifically about the best authentication method to use when connecting to the SQL endpoint from ASAzure. From my testing, it appears that both Service Principal and Managed Instance authentication methods are not supported, or at least that's the error I’m encountering.

For context, we have scripts that successfully use Service Principal credentials to pull data via the SQL endpoint without any issues. This leads me to believe the problem lies with ASAzure, which seems to only accept OAuth2 authentication. Could you confirm if this is the case or suggest a better approach?

    • danjo914's avatar
      danjo914
      Frequent Visitor
      1 year ago

      There are two authentications required, one the authentication to the ASAZURE, which yes, we are using the service principal already, but the second is the authentication to the data source located inside the .bim file. That does not seem to support managed identities nor service principals. We get "This authentication type is not supported".  It appears that only OAUTH2 can be used inside the .bim to connect to the sql endpoint inside a Microsoft Fabric Workspace with a token expiry of a single day. It would be great if I am incorrect. Happy to hear of other ways to set up authentication to the datasource.