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.

• Ben Gribaudo

  1 Recording
  Author 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 44 Recordings

Nov 11, 2020

• PowerBI 11 Recordings