Forum Discussion
Filter and pulling few columns from Dataflow in Power Query
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.
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?
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.