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 an 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 a couple of ways to create a new query group in power bi
The 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)
The 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
The 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 the 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.
The 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.
