Azure Data Flow connection error to Dynamics 365 but pipeline can

Question

I have a pipeline that has a connection to a table in Dynamics 365 which works fine. I need to create a dataflow as I need to lookup a value in the source that then replaces the value with a guid to load into Dynamics 365 but when I do a data preview in the data flow reading the Dynamics connection I get the following error:

UserPasswordAuthenticator fail to get access token with exception: java.util.concurrent.ExecutionException: com.microsoft.aad.msal4j.MsalInteractionRequiredException: AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access

I do not get this error when connecting via the pipeline.

It seems to be a similar issue to the one mentioned here:

https://learn.microsoft.com/en-us/answers/questions/938311/azure-data-factory-data-flow-rest-api-access-token

But there is no resolution mentioned in the comments.

Answer 1

I did the following on a different Azure subscription and the connection to Dynamics as a source in the dataflow worked fine. When creating the source:

1. in source settings select Inline, don't complete the dataset type and linked service with dataset and then swap to inline (imho) then select the inline dataset type and then the linked service
2. inline dataset type for me is Dynamics 365
3. In source options I started with a entity name and then checked that Projection and Data Preview returned data and field names
4. Then swapped to a query as I want to filter the table
5. Learnt fetchXML from MS Learn at https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/filter-rows?tabs=fetchxml

Works like a charm