Search code examples
azuredynamics-crmazure-data-factorymicrosoft-dynamics

Getting no projection from Dynamics CRM dataset


I am trying to get data from Dynamics in my Data Factory, but somehow I'm not seeing column output when I try to use the dataset in my Data Flow.

When I use the 'Preview data' option in my Dynamics dataset I'm getting result, so that looks fine. But when I try to use my Dataset as a source in my Data Flow no columns/fields are visible in the 'Projection' tab.

Source settings

Projection

Has anyone ever had this problem? I've already spent hours on this, but I can't getting it to work.


Solution

  • I solved this issue by using a 'copy data' activity like this:

    Source