Forum Discussion
ASAZURE to Fabric Warehouse SQL Endpoint
Hi danjo914,
AFAIK, Azure AS can support to use service principal, have you configuration this on your Azure AS side before you test?
Learn how to add a service principal to Azure Analysis Services admin role | Microsoft Learn
Regards,
Xiaoxin Sheng
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.
HI danjo914,
Did you means the multi-fact authorization? AFAIK, if you enable this on Azure AD, it will require you to provide additional trusted authorization to verify and confirm the security of these operations.
Enable Microsoft Entra multifactor authentication - Microsoft Entra ID | Microsoft Learn
Regards,
Xiaoxin Sheng