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