Forum Discussion
Filter and pulling few columns from Dataflow in Power Query
Hello, I am writing this post to check whether we can achieve the following scenario in Power Query or not. I have created a data flow with more than 30 columns that can be used for multiple reports...
Hello Pat,
Thank you for your response. But, I don't want to import the entire data flow and choose columns or apply a filter. What I want to do is out of 30 columns in the dataflow pull only specified columns and apply a filter like where column1 = USA.
Thanks,
Sri
As far as I know, Dataflows don't yet "fold" (push the filter/select back to the source), so each refresh will bring in the full data and then you reduce it from there. I hope that changes soon.
Regards,
Pat