This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What is the primary purpose of a dataflow in Microsoft Fabric?
To create visualizations and reports from raw data
To extract, transform, and load data using a low-code Power Query interface
To manage workspace security and access permissions
What is query folding?
The process of combining multiple queries into a single query for efficiency
The process of pushing transformation logic to the data source for execution instead of processing it in the Power Query engine
The process of organizing applied steps into folders for better readability
Which transformation combines rows from two queries into a single query, similar to a SQL JOIN?
Append queries
Group by
Merge queries
How can you check whether a specific applied step folds to the data source?
Open the Advanced Editor and look for SQL syntax in the M code
Right-click the step in the Applied Steps pane and check if View Native Query is available
Run the dataflow and check the refresh history for folding status
When is a notebook a better choice than a dataflow for data transformation?
When the team prefers a visual drag-and-drop interface
When transformations involve filtering rows and removing columns
When transformations require complex logic or large-scale distributed processing
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?