Since version 6675.2 it is possible to use a Service Principal for authentication on SQL databases:
“You can now use Windows, Entra Password, Entra Integrated, and Entra Service Principal authentication for ODX SQL storage in addition to the existing SQL Server Authentication.”
However, when you are using ADF for data transfer from ODX to DWH it is not possible to authenticate using a Service Principal. You would get this error:
I would like to use a Service Principal in combination with Azure Data Factory too.
