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

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.