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 ,

Thanks for using Fabric Community.
Can you please share the screenshot of the next page and describe little about your issue, so I can guide you better?

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.