Which command is used in Power BI Desktop query editor to create a query that sources from another query?

Prepare for the Power BI Certification Exam with interactive quizzes and detailed explanations. Improve your understanding of Power BI with comprehensive study materials and practice questions. Get exam-ready today!

In Power BI Desktop's query editor, the command used to create a query that sources data from another query is "Reference." This command allows users to build a new query based on the results of an existing query, effectively creating a linked or dependent query. This is particularly useful when you want to create variations of the data from the original query without having to start from scratch or modify the original data set. Referencing is a powerful feature because it ensures that any changes made to the original query are automatically reflected in the referenced query, maintaining consistency and reducing redundancy.

The other options serve different functions in Power BI. "Pipe" is not a recognized command for creating queries. "Duplicate" creates a complete copy of an existing query, which doesn't maintain a live connection to the original. "Merge" is used to combine data from two or more queries into a single query, rather than creating a new query that references another. Therefore, "Reference" is the most appropriate choice for sourcing a query from another query.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy