Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
5 years ago
Solved

how 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?
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.