Este artículo muestra los pasos necesarios para crear grupos de consultas en Power BI con un ejemplo. En general, las tablas que cargamos desde la fuente están ordenadas alfabéticamente. Sin embargo, en tiempo real, es posible que tengamos que agrupar esas tablas según el contents.
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.
<>Clicking Edit queries The option opens a new window called Editor de Power Query. Under Power BI Queries section, you can see the list of available tables.
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.
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.
You can see the New folder (query group)
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.
You can now see the DimCustomer table in the Dimensions group
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.
Similarly, we add the remaining dimension tables to the Dimension query group.
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.
Select the New group.. The option will open the following window. For now, we are assigning the group name as measures.
Reorganize tables in a Power BI query group
Simply moving the table up and down will change the position of the table.
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.
You can now see the Dim Employee table in the third position.
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.
Select the Delete group The option opens the following message box. For now, we are clicking on the Cancel button
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.
Now you can see that the Dimensions group has been removed.
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.
Now you can see that the measure group is nested within the dimension group.
You can undo this by right-clicking on the group name and selecting the Move to the top level context menu option
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.
