CHRISTOPHER REYNOLDS on 15 Jan 2021 01:36:43
I have a dataflow with a billion rows. Currently, I have to create several references of this dataflow with various date ranges and aggregations. Ideally, I'd be able to do this in the dataset by the Query Folding feature. This type of Query Folding is possible with database sources, but not with DataFlows.
Administrator on 14 Oct 2021 21:39:24
The ability for dataflow sources to support query folding into a Power BI dataset now exists, to learn more please visit: https://powerbi.microsoft.com/en-us/blog/power-bi-august-2021-feature-summary/#post-16859-_Toc79419594
- Comments (1)
RE: Query Folding for DataFlows from a DataSet
This would be great improvement even for smaller dataflows. I am guessing Microsoft could do some magic by utilizing the Enhanced Compute Engine (well described here: https://ssbipolar.com/2019/10/12/power-bi-dataflows-and-query-folding/)