Authentication method for copy job and OData connector as a source

[pmscorca]

Hi,

I need to use a copy job in order to manage full and incremental data load from a Dynamics Business Central source by the OData connector, but it seems that this connector doesn't support the Organizational account authentication.

I think that it is a great limitation and I don't understand the reason.

I don't want to use a Dataflow gen2.

Why does OData connector not support the Organizational account authentication, please?

F.e. BC requires a such authentication type.

Thanks

[v-lgarikapat]

Hi @pmscorca ,

Thanks for reaching out to the Microsoft fabric community forum.

I recommend submitting this scenario as a feature request on the official Fabric Ideas forum. The Product Team actively reviews submissions there, and suggestions with strong community support are often considered for future enhancements.

https://ideas.fabric.microsoft.com/

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[pmscorca]

Ok, I've submitted the related idea: Organizational account authentication for the OData connector used in a copy job as a source but the question remains, also because the Organizational account authentication is supported for a Dataflow gen2

[v-lgarikapat]

Hi @pmscorca ,

Apologies for the late reply

Thank you for submitting the scenario to the Ideas Forum and for the confirmation

The Copy Activity (or Copy Job) in Microsoft Fabric and Azure Data Factory is built for automated, scalable, and unattended data movement. That design philosophy is the key reason why Organizational Account authentication (interactive AAD login) isn’t supported:

• Organizational Account auth requires user interaction typically a browser-based login or token refresh tied to a specific user session.

• Copy Activity runs headless, often triggered by pipelines or schedules, where no user is present to complete the login flow.

So while Dataflow Gen2 supports Organizational Account (because it can run in a semi-interactive context), Copy Activity does not, because it’s optimized for automation.

Using OAuth to authenticate Business Central Web Services - Business Central | Microsoft Learn

Best Regards,

Lakshmi.

[pmscorca]

Ok, but also a Dataflow Gen2 could be called by a data pipeline.

Using Copy activity (or Copy job) and OData connector is there any best practices about the authentication type to use? Thanks