I am trying connecting data factory to SQLMI using Managed identity.
I was able to create the linked service. when I test the connection it shows that the connection is successful.
Even when I create a dataset I am able to preview the data.
The problem occur when I use Data Flow/Data Flow debugger the below error message is displayed:
"Please check the linked service configuration is correct, and make sure the SQL database firewall allows the integration runtime to access".
the SQLMI public endpoint is enabled.
when we use a SQL Authentication (as opposed to managed identity) linked service we have no problem and Data Flow works normally.
