Power BIPowerBI tutorials

Create query groups in Power BI

Power BIPowerBI tutorials

Create query groups in Power BI

This article shows the steps to create query groups in Power BI with an example. In general, the tables we load from source are arranged alphabetically. However, in real time, we may have to group those tables based on content.

For example, organize dimension tables in one group and fact tables in another.

How to create query groups in Power BI

To create the Power BI query group on existing tables, click the Edit queries option under the Home tongue.

create-query-groups-in-power-bi-1-9113125

Clicking Edit queries The option opens a new window called Power Query Editor. Under Power BI Queries section, you can see the list of available tables.

create-query-groups-in-power-bi-2-5960892

There are a couple of ways to create a new query group.

The first approach to creating a Power BI query pool

To create a new query group, right-click on the empty space below the inquiries section and select the New group context menu option.

create-query-groups-in-power-bi-3-2456902

Select the New group The option will open the following window. Specify the group name and description. For now, we assign the Dimensions as the Group name.

create-query-groups-in-power-bi-4-8215042

You can see the New folder (query group)

create-query-groups-in-power-bi-5-8293059

The first approach to adding tables to query groups in Power BI

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

create-query-groups-in-power-bi-6-7838828

You can now see the DimCustomer table in the Dimensions group

create-query-groups-in-power-bi-7-3173851

The second approach to adding tables to query groups in Power BI

Drag the required table and drop below the query group to automatically add that table to the query group. For demonstration purposes, we are dragging the Dim Employee table to the Dimension group.

create-query-groups-in-power-bi-8-1194558

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

create-query-groups-in-power-bi-9-6840025

The second approach to creating Power BI query pools

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

create-query-groups-in-power-bi-10-3284712

Select the New group.. The option will open the following window. For now, we are assigning the group name as measures.

create-query-groups-in-power-bi-11-4577827

Reorganize tables in a Power BI query group

Simply moving the table up and down will change the position of the table.

create-query-groups-in-power-bi-12-6118348

Alternatively, right-click on the table you want to move to open the context menu. Please select the Move down or Ascend option. For the purpose of the demo, we moved the Dim Employee table down.

create-query-groups-in-power-bi-13-8223481

You can now see the Dim Employee table in the third position.

create-query-groups-in-power-bi-14-6367701

Delete query groups in Power BI

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

create-query-groups-in-power-bi-17-5387656

Select the Delete group The option opens the following message box. For now, we are clicking on the Cancel button

create-query-groups-in-power-bi-16-8536005

How to ungroup existing query groups in Power BI

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

create-query-groups-in-power-bi-18-7668360

Now you can see that the Dimensions group has been removed.

create-query-groups-in-power-bi-19-2659337

Nested query groups in Power BI

To add a group within another group, right-click on the group name to open the context menu. Please select the Move group option and then select the name of the Master Group, that is, Dimensions.

create-query-groups-in-power-bi-20-4292967

Now you can see that the measure group is nested within the dimension group.

create-query-groups-in-power-bi-21-3951123

You can undo this by right-clicking on the group name and selecting the Move to the top level context menu option

create-query-groups-in-power-bi-22-4180356

Whatever changes you have made (query groups) will not affect you until you press Apply. Let me hit the Close and apply option under the Home tongue.

create-query-groups-in-power-bi-23-4305077

This article shows the steps to create query groups in Power BI with an example. In general, the tables we load from source are arranged alphabetically. However, in real time, we may have to group those tables based on content.

For example, organize dimension tables in one group and fact tables in another.

How to create query groups in Power BI

To create the Power BI query group on existing tables, click the Edit queries option under the Home tongue.

create-query-groups-in-power-bi-1-9113125

Clicking Edit queries The option opens a new window called Power Query Editor. Under Power BI Queries section, you can see the list of available tables.

create-query-groups-in-power-bi-2-5960892

There are a couple of ways to create a new query group.

The first approach to creating a Power BI query pool

To create a new query group, right-click on the empty space below the inquiries section and select the New group context menu option.

create-query-groups-in-power-bi-3-2456902

Select the New group The option will open the following window. Specify the group name and description. For now, we assign the Dimensions as the Group name.

create-query-groups-in-power-bi-4-8215042

You can see the New folder (query group)

create-query-groups-in-power-bi-5-8293059

The first approach to adding tables to query groups in Power BI

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

create-query-groups-in-power-bi-6-7838828

You can now see the DimCustomer table in the Dimensions group

create-query-groups-in-power-bi-7-3173851

The second approach to adding tables to query groups in Power BI

Drag the required table and drop below the query group to automatically add that table to the query group. For demonstration purposes, we are dragging the Dim Employee table to the Dimension group.

create-query-groups-in-power-bi-8-1194558

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

create-query-groups-in-power-bi-9-6840025

The second approach to creating Power BI query pools

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

create-query-groups-in-power-bi-10-3284712

Select the New group.. The option will open the following window. For now, we are assigning the group name as measures.

create-query-groups-in-power-bi-11-4577827

Reorganize tables in a Power BI query group

Simply moving the table up and down will change the position of the table.

create-query-groups-in-power-bi-12-6118348

Alternatively, right-click on the table you want to move to open the context menu. Please select the Move down or Ascend option. For the purpose of the demo, we moved the Dim Employee table down.

create-query-groups-in-power-bi-13-8223481

You can now see the Dim Employee table in the third position.

create-query-groups-in-power-bi-14-6367701

Delete query groups in Power BI

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

create-query-groups-in-power-bi-17-5387656

Select the Delete group The option opens the following message box. For now, we are clicking on the Cancel button

create-query-groups-in-power-bi-16-8536005

How to ungroup existing query groups in Power BI

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

create-query-groups-in-power-bi-18-7668360

Now you can see that the Dimensions group has been removed.

create-query-groups-in-power-bi-19-2110674

Nested query groups in Power BI

To add a group within another group, right-click on the group name to open the context menu. Please select the Move group option and then select the name of the Master Group, that is, Dimensions.

create-query-groups-in-power-bi-20-6079810

Now you can see that the measure group is nested within the dimension group.

create-query-groups-in-power-bi-21-2742825

You can undo this by right-clicking on the group name and selecting the Move to the top level context menu option

create-query-groups-in-power-bi-22-7727118

Whatever changes you have made (query groups) will not affect you until you press Apply. Let me hit the Close and apply option under the Home tongue.

create-query-groups-in-power-bi-23-4305077
error: Attention: Protected content.