Question 108262 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – 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.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

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

    Source


  2. 0

    First go to Dataset and In Schema tab click on Import schema.

    enter image description here

    Now go to Projection and click on Import projection.

    enter image description here

    Refer – https://learn.microsoft.com/en-us/azure/data-factory/data-flow-source#projection

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search