To move a given query to a Query group, right-click in a query and select Move to group. You can make folders and move the queries into these folders for organizational purposes. To reference a query, right-click in the query and select Reference. Additionally, any changes on the original query will transfer down to the referenced query. The new query will use the steps of the previous query without having to duplicate the query. Referencing a query will create a new query. A new duplicate query will appear in the diagram view. To create a copy of a given query, right-click in the query and select Duplicate. The queries where Enable load is set to false will be displayed with a grey outline. In case you need to disable load for a given query, right-click in a query and select Enable load. To ensure that the results provided by the query are available for downstream use such as report building, by default Enable load is set to true. To rename a query, right-click in a query and select Rename from the context menu. There will be an additional pop-up to confirm the deletion. To delete a query, right-click in a query and select Delete from the context menu. You can also select the highlight related queries button on the top-right of a query.įor example, if you select the highlight related queries button in the Top US Customers query, you can see that the Customers and Orders queries are highlighted. To view all the related queries for a given query, right-click in a query and select Highlight related queries. You can also double-click in the query to expand or collapse a query. To expand or collapse a query, right-click in the query and select Expand/Collapse from the query's context menu. You can also right-click in the query and get to the same context menu. You can perform more query level actions such as duplicate, reference, and so on, by selecting the query level context menu (the three vertical dots). These quick actions show up on an active selected query or when hovering over a query. You can perform two quick actions on a query- expand/collapse a query and highlight related queries. To learn more about how to author queries in the Query editor using the Power Query editor ribbon or data preview, go to Power Query Quickstart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |