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?
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!