How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding
When a mashup is executed, sometimes the engine pulls rows one at a time (streaming). Other times, it translated a portion of the expression into the data source’s native query language (e.g. SQL) then offload its processing to that source (query folding). These behaviors affect execution efficiency (speed, memory usage, etc.), result accuracy (such as whether two aggregations returned by the same mashup are computed from the exact same data set) and data privacy/cross-source data sharing (think: privacy levels). This segment’s goal is to equip you with foundational understanding of these key concepts.
1 RecordingAuthor of the ongoing Power Query M Primer Series, an in-dept dive into the Power Query language, Ben Gribaudo is a seasoned solutions engineer whose expertise includes data engineering, business intelligence, software development, architecture and business analysis.
- Austin Power BI User Group 14 Recordings
Nov 11, 2020
- PowerBI 6 Recordings