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

Azure – i can't connect to input container. but the container is acccessible and the file is there

I learning azure, specifically datafactory, so in a basic exercice.

1 – I should create a input container, and a output container (using azure sorage 2).

2 – After that, i created the datasets for input and output.

3 – And finally. I should connect the dataflow to my input dataset.

but

i can test conections on the datasets to prove that i created it without problems. but i cant test the connection on my dataflow to the input dataset.

enter image description here

i tryed

  • recreating it with different names.
  • keep only the needed file in the storage
  • use different input file (i am using a sample similar to the "movies.csv" expected to the exercise.
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I think I found the solution.

    when i am working with "debug on" and for some reason i create another "data flow", you cant connect to the new datasets.

    But

    if I restart the debug (put off and on again), the connections start working again.


  2. 0

    I created azure blob container and uploaded file

    enter image description here

    I created linked service with azure storage account

    enter image description here

    I created a dataset with above linked service following below procedure:

    enter image description here

    enter image description here

    enter image description here

    I tested the connection, it connected successfully.

    enter image description here

    I didn’t get any error. The error which you mentioned above is related to dynamic content. If you assign any parameters in dataset provide the values of parameters correctly. I added parameters in dataset as below

    enter image description here

    I try to test the dataset I got error:

    enter image description here

    I added values for parameters in debug settings

    enter image description here

    Tested the connection, it connected successfully

    enter image description here

    Otherwise add the sink to the dataflow and try to debug it, it may work.

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

Back To Top
Search