Forum Discussion

Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
5 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
5 years ago

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's avatar
v-yingjl
Community Support
5 years ago

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.