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 ,

As I understand you will get output of the sql query mentioned during connection in PQ View.
I am unable to understand why are you expecting a different tree view structure?
Are you expecting to connecting to your On-Prem SQL Server directly in Fabric?

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.