No LinkedService Parameters available in Mapping Data Flow INLINE -Error on Test Connection

Sirmad Mohammad 41 Reputation points
2021-10-29T12:49:29.46+00:00

Hey there,

we got a problem with passing parameters from any LinkedService
to the source of the Mapping Data Flow. The connection has an error in the data Flow, it is not possible to define the "storagename" inside the settings of the Source !

Is there any solution to this ?

Linked Service:
145015-blob.jpg

145016-df.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,216 questions
0 comments No comments
{count} votes

Accepted answer
  1. Saurabh Sharma 23,826 Reputation points Microsoft Employee
    2021-11-16T23:34:34.047+00:00

    Hi @Sirmad Mohammad ,

    I have got the confirmation from products team that unfortunately this is a current known product limitation that engineering is currently working on adding to Dataflow. We do not have any concrete ETA for this due to holidays however but it will be tentatively available between December - January time.

    Please let me know if you have any other questions.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Saurabh Sharma 23,826 Reputation points Microsoft Employee
    2021-11-04T23:28:44.4+00:00

    Hi @Sirmad Mohammad ,

    Thanks for using Microsoft Q&A !!

    You need to pass linked service parameters from the dataset where you are using the Linked Service. Please find below the screenshot for the same.

    1. Linked Service
      146660-image.png
    2. Dataset (Provide storage name here and test the connection)

    146667-image.png

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    0 comments No comments

  2. Sirmad Mohammad 41 Reputation points
    2021-11-05T07:46:11.93+00:00

    Hi @Saurabh Sharma ,

    thank you for looking into it.

    It is clear that it works for the DATASET setting in the data flow, but it does not work for the INLINE data Setting in Mapping Data flows.

    As we want to use DevOps Pipelines for the Deployment to Prod, we want to specify the parameter of the linked Service from Outside (devops).
    With the Dataset setting it is possible in the Source setting to change the given LinkedService Parameter, but the Inline Source Option does not have any window to change that.

    Best,

    Sirmad


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.