Create Query Groups in Power BI

In general, the tables that we load from the source will be arranged in the alphabetical order. However, in real-time we might have to group those tables based on the content. For example, arrange Dimension tables in one group, and fact tables as another. In this article, we will show you, the steps required to Create Query Groups in Power BI with example.

How to Create Query Groups in Power BI

In order to create query group on existing tables, please click Edit Queries option under the Home tab.

Clicking Edit Queries option will open a new window called Power Query Editor. Under the Queries section, you can see the list of tables that are available.

There are couple of ways to create a new query group in power bi

First approach to Create Power BI Query Group

In order to create a new query group, right-click on the empty space under the queries section and select New Group option from the context menu.

Selecting the New Group option will open the following window. Please specify the Group Name, and the description. For now, we are assigning the Dimensions as the Group name.

You can see the New folder (Query Group)

First approach to add Tables to Query Groups in Power BI

Right-click on the table that you want to add will open the context menu. Please select the Move to Group option, and then select Group Name i.e., Dimensions

Now you can see the DimCustomer table under the Dimensions group

Second approach to add Tables to Query Groups in Power BI

Drag the required table and Drop under the Query group will automatically add that table to query group. For the demonstration purpose, we are dragging Dim Employee table to the Dimension group.

Similarly, we added remaining dimension tables to the Dimension query group.

Second approach to create Power BI Query Groups

In order to create a new query group, right-click on any table will open the context menu. Please select the Move to Group option, and then select New Group option.

Selecting the New Group.. option will open the following window. For now, we are assigning the Group name as measures.

Rearranging tables in a Power BI Query Groups

By simply moving the table up and down will change the table position.

Alternatively, right-click on the table that you want to move will open the context menu. Please select the Move Down or Move Up option. For the demonstration purpose, we moved Dim Employee table to down.

Now you can see the Dim Employee table at third position

Delete Query Groups in Power BI

In order to delete the existing query group, right-click on the group name will open the context menu. Please select the Delete Group option.

Selecting the Delete Group option will open the following message box. For now, we are clicking the Cancel button

How to Ungroup existing Query Groups in Power BI

To ungroup or remove the existing group, right-click on the group name and select Ungroup option from the context menu.

Now you can see that the Dimensions group is removed

Nested Query Groups in Power BI

In order to add one group inside another group, right-click on the group name will open the context menu. Please select the Move to Group option, and then select the Master Group name i.e., Dimensions.

Now you can see that the Measures Group is Nested inside the Dimensions group

You can undo this by right clicking the group name and selecting the Move to Top Level option from the context menu

Whatever the changes you made here will not effect until you hit Apply. Let me hit Close & Apply option under the Home tab.