Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.