Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.