Applied Steps and Re-quering Data Source

[Anonymous]

Using Power Query, each time you change a field type or expand a column does the step result in the data source being re-queried?

Steps:
connect to a data source

filter rows

change column type

expand column

Would the steps outlined above result in one query back to the data source or multiple?

[lbendlin]

Usually one (there are some exceptions for schema retrieval - https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/ )

BUT- oftentimes it also results in zero queries for some steps when Query Folding is active.  That means any previous steps are combined into one native query.