Forum Discussion
Power Participanthow to find a query quickly
I'm dealing with a complex datset where are dozens of different queries in the Power Query module. Is there a quick way to locate the query I need, e.g., by key word search?
Hi Jeanxyz ,
In Power BI Query Editor, if you go to Advance Editor on the top ribbon, it will show you all the steps that you have applied on your data.
Whenever a transformation is done on Power Query Editor, a step is created. If you have given appropriate name to your steps, then you can do a search for the step name in Advance Editor code. If not then you will have to check the steps one-by-one and see what transformation every step is performing on your data. (this can ve just done by naviagting to different steps under Applied Steps section on the right).
Thanks,
Pragati
2 Replies
- Pragati11
Super User
Hi Jeanxyz ,
In Power BI Query Editor, if you go to Advance Editor on the top ribbon, it will show you all the steps that you have applied on your data.
Whenever a transformation is done on Power Query Editor, a step is created. If you have given appropriate name to your steps, then you can do a search for the step name in Advance Editor code. If not then you will have to check the steps one-by-one and see what transformation every step is performing on your data. (this can ve just done by naviagting to different steps under Applied Steps section on the right).
Thanks,
Pragati
V-lianl-msftCommunity Support
You can manage your queries either in the Queries pane of the Power Query Editor or on the Queries tab of the Queries & Connections pane in power bi. This is especially helpful if you have many queries and you want to quickly locate a query.