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. I want to filter the data and also pull only a few columns from Dataflow into the Power BI desktop. Please let me know if I could do this or not.
Thanks in advance,
Sri
7 Replies
Hello Srikanth7Gunnam , I had the same scenario as yours and I could accomplish the same by adding a simple Table.SelectColumns before that gigantic code that identifies the dataflow in the NAVIGATION step, and after that I have put all the columns I need, so that my dataflow didn't have to bring all the columns. Like this:
Navigation = Table.SelectColumns(#"b133dc8e-5a93-4ede-4370-04cadb13f4d6"{[entity="Data",version=""]}[Data],{"Colum1","Column2", "Column3", "Column4"})If I have answered your question, please mark my post as solution 😄
Have a good day!Yes. Choose Power BI Dataflows as your source/connector, navigate to your Dataflow, and then click on Choose Columns in the ribbon.
Pat
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,
SriAs 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
