Query Folding

July 15, 2021

How to use Native SQL Queries on Excel Data with Power Query

Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability to push data transformation tasks to the data source level, rather than on Power Query