Filter and pulling few columns from Dataflow in Power Query

[Srikanth7Gunnam]

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

[Muniz_Felipe]

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!

[mahoneypat]

Yes.  Choose Power BI Dataflows as your source/connector, navigate to your Dataflow, and then click on Choose Columns in the ribbon.

Pat

[Srikanth7Gunnam]

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

[v-yingjl]

Hi @Srikanth7Gunnam ,

If you do not want to import all the data into power query from dataflows, you can filter it directly in dataflows, then connect to it in power query.

The steps you have filtered data in dataflows are the same as in power query, like remove unnecessart columns, filter specific values etc.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Srikanth7Gunnam]

Hello,

Thank you for your reply. But, my data flow is a centralized data source for multiple reports. I can't filters in the dataflow as it has data about all the countries and I have reports for each country individually. So, I want to fold the query while importing. Can you please tell me whether we can do it or not?

[v-yingjl]

Hi @Srikanth7Gunnam ,

As far as I know, when accessing dataflow entities from Power BI Desktop, no query folding takes place, even if the enhanced compute engine is enabled. Please refer this article: Power BI dataflows and query folding 

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

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