Forum Discussion
Default query when opening Power Query?
Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
The file is auto opening on Hormel because your target query is part of an active dependency chain (you show Source = Table.Combine({Hormel, #"Not Hormel"}) and several Table.NestedJoin steps).
Make a truly independent landing query. Either create a topmost Landing query with no references or duplicate the Sales history query and inline the actual source steps from Hormel and Not Hormel into the duplicate (rename those local blocks and set Source = Table.Combine({Source_Hormel, Source_NotHormel})) so the duplicate has no incoming arrows in View -> Query Dependencies. Save the PBIX, fully close Power BI and reopen, the editor will then open to that independent query.
Hi,
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.
Hi Anonymous,
Unfortunately, Power BI Desktop does not currently allow you to set a default query that opens automatically when you click Transform Data. By design, this button always opens the Power Query Editor showing the last query you were working on in that session.
If your question is about heavy load.
Possible Workarounds:
Use a “Landing Page” Query
- Create a blank query named something like Home or Start Here.
- Add a simple note in the query (e.g., using = "Welcome to Power Query").
- Before saving your PBIX, make sure this query is the last one you view in the editor. Power BI will reopen the editor on the last active query.
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
That doesn't work.