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 to ingest via gen2. I can query the data via sql statement as below.

 

But what is happening afterwords in next screen(PQ window) is i am not getting the actual tables as a hierarchy of tables to select,instead table names in tabular format.
So that kind of requirement can we do with dataflows gen 2, pipeline activity in fabric.since it is difficult to select one by one tables in the UI if it is having 1000+ etc views/tables.

Thanks in advance

Dataflows
Need Help

11 Replies

  • 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?