Query groups

You should also use query Groups to help isolate data source and staging queries from queries loaded to the dataset.

1. Duplicate a query or copy and paste via the right-click context menu for a query.
2. Create a new group by right-clicking in a blank area in the Queries window or an existing group.
   • With the DimEmployee table referencing the source query, you can simply duplicate this query and then revise the Navigation step (via Navigator or Formula Bar) to retrieve a different table from this source into the model, such as the Account dimension table.

1. Ensure that the Data Source queries are not loaded to the data model.
   • Right-click on the tables and disable the Enable Load option such that they only exist to support retrieval queries and are invisible to the model and report layers.

The Query Dependencies view in the Query Editor (View | Query Dependencies) provides a visual representation of the relationships similar to the Diagram view available for Power BI Desktop's data modelling component.