Welcome to the Austin Power BI User Group (PUG). We are helping each other accelerate our understanding of Power BI and related Microsoft Technologies. Our mission is to empower organizations and members to obtain new insights based on data.
We're always looking for Keynote Speakers and Topics, please reach out however you feel comfortable if you are interested so that we can discuss further.
Note: We are going virtual for this one. Do NOT go to the Microsoft Office.
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.
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.
For presentation materials, discussions, and Q/A, please visit: