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
nalakan's avatar
nalakan
Frequent Visitor
2 years ago

Yes.via gateway .
It is not a different tree view .I just need to filter the tables based on my condition that mentioned earlier.

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?