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 token only lasts a day. We want to automate this using Microsoft Azure Automation however, it doesn't seem to support Managed Instances or Service Principals and requires us to use a OAUTH2 username/password each time we want to process.  Surely that is not intended, does anyone have a work around? I believe the issue the connection ot the Microsoft Fabric Warehouse requiring an OAUTH2 but then how would you go about automating it without embedding usernames and passwords?

data engineering

5 Replies

    • 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?