Forum Discussion
Anonymous
11 months agoNot applicable
Default query when opening Power Query?
Hi - is there a way to specific which query opens when you select Transform Data from the menu bar? I've tried changing it and saving, renaming it to "01-queryname" and I can't get it to work. ...
IrinaTokm
Advocate I
10 months agoHi,
As far as I know, there is no way to set a default query for Transform data.
In your case Sales history depends on Hormel and Not Hormel, so Power Query opens the first query in that chain (Hormel).
A simple workaround is to create a new query that just references Sales history and move it to the top of the Queries list, or right-click Sales history in the Fields pane and choose Edit query to open it directly.