Azure Data Flow connection error to Dynamics 365 but pipeline can

Wayne Bartkowski 656

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.

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-03-04T16:51:02.67+00:00

Hi Wayne Bartkowski,

Thank you for posting query in Microsoft Q&A Platform.

If I understand correctly, you have linked service for Dynamics 365 and created dataset for a table in it.

When you use this dataset in pipeline, copy activity, you are able to successfully copy. But when you use this dataset in dataflows and perform data preview, then ending up with error? Kindly confirm if its correct?
Wayne Bartkowski 656 Reputation points

2024-03-04T22:10:32.43+00:00

Hi ShaikMaheer - yes that is correct
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-03-06T06:03:28.78+00:00

Hi Wayne Bartkowski,
I am trying to see if internal team can help on this. Could you please this issue only when using Source type as Dataset or even when using Inline source type in MDF? Also if you have a support ticket already created for this, please do share this information with us.
Wayne Bartkowski 656 Reputation points

2024-03-06T22:37:18.88+00:00

I haven't created a support ticket at this point. I am using a Dynamics 365 connection for the linked service with the details as, Deployment Type = Online, Service URI = my dynamics trial url, Authentication Type = Office365, ten I se my user name and password. This work fine in the pipeline but not in the Data Flow
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-03-28T10:10:40.8266667+00:00

Hi Wayne Bartkowski, Kindly try using inline dataset and see if that helps.
Wayne Bartkowski 656 Reputation points

2024-04-03T00:29:41.0066667+00:00

Hello ShaikMaheer - I only see Online or OnPremisesWithlfd in the deployment type
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-12T06:37:26.5266667+00:00

Hi Wayne Bartkowski, Inline dataset option will be there in dataflows.
Wayne Bartkowski 656 Reputation points

2024-04-16T07:31:29.6533333+00:00

Thanks - yes I see in the data flows in Source Settings - Source Type - Dataset or Inline. But the same error appears for either of them