Change the Power Query Default Load Location

In this video, we change the default load location for power queries to connection only and to the data model.

The Power Query default load location is to a Table and on a new worksheet. This is not great when handling multiple queries, and some of them may be staging queries.

The good news. It is simple to change the default load location, and this video shows you how.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[IvanCortinas_ES]

This is important because on many occasions we don't want to load the queries in the spreadsheets. It is very practical what you have told Alan!

[premdale]

I am often asked which is the simplest way in PQ to change format of say $1, 234, 557 to $1.23M (with negatives in RED in brackets) Dead easy in BI, some simple VBA in Excel but the FORMAT in PQ I find clunky.. Might make a good topic!! love your work and you are getting popular down under!!

[JCEurovisionFan]

Alan, could you do a challenge and a tutorial on how to do the ranked-choice voting (instant runoff voting) on Excel and on Google Sheets?

[jay-marcloydcreila]

Hi there!
Can you do a video why power query stopped loading data after a 1million rows? Is it due to laptop specs?

[sasdas]

Thank you, but I have a question, I have already loaded a query into a table, but now I want to change that specific query to "connection only", do we have any such option available.

[michaelt]

Anyway to get them to load on one page?