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. |