Forum Discussion

nalakan's avatar
nalakan
Frequent Visitor
2 years ago

Filtering selected tables with data in Dataflow Gen2 to Fabric

Hi Folks, I am trying to ingest data from on prem sql server to fabric via data flowflow Gen2 .I just need to select a particular schema(e:g finance) and views that starting from letter "X" ,i need ...
Dataflows
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi nalakan ,

Did you got a chance to check this option?
With the help of the filter you can select the required rows.

nalakan's avatar
nalakan
Frequent Visitor
2 years ago

yes.this is only filtering table names.related data in the tables can not obtained in this method.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi nalakan ,

    You can get below view if you do connection directly without mentioning the query.

     


    Please let me know if this is what you are looking for.

    • nalakan's avatar
      nalakan
      Frequent Visitor
      2 years ago

      This is fine for few tables.but as i mentioned ,i have 1000 + tables.so it is not practical to invdiually select the tables starting from letter  "x" .You got my requirement?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi nalakan ,

        I was able to understand your issue. Unfortunately at present we only have this option.

        Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
        Feedback Link : Home (microsoft.com)

        Hope this helps. Please let me know if you have any further questions.