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.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

    Oh,is that so...
    Sure.vl share via feedback link.
    Thanks for your support.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi nalakan ,

    I hope you got some insights on your query. You can let me know if there is any further queries.
    Please continue using Fabric Community on your further queries.

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi nalakan ,

    I was able to understand your issue. Unfortunately at present we only have this option.

    Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
    Feedback Link : Home (microsoft.com)

    Hope this helps. Please let me know if you have any further questions.