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

Thanks. Anonymous 
(sry for the blurred image)

What i want is yellow coloured tables as a tree view in left side with data as normal import scenario in gen2.( purple color).

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.