Power Query for Excel Enable load!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-436890%22%20slang%3D%22en-US%22%3EPower%20Query%20for%20Excel%20Enable%20load%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-436890%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EDoes%20PowerQuery%20for%20Excel%20has%20the%20option%20to%20stop%20loading%20some%20queries%3F%3C%2FP%3E%3CP%3EI%20Collect%20data%20from%20multiple%20sources%20and%20then%20append%20them%20to%20one%20query%2C%20then%20when%20I%20load%20the%20data%20all%20the%20queries%20and%20tables%20are%20loaded%2C%20the%20original%20and%20the%20appended%20tables%2C%20this%20results%20in%20data%20duplication%20in%20reports.%20I%20found%20an%20option%20in%20Power%20BI%20to%20enable%20or%20disable%20loading%20data%20for%20selected%20queries%20in%20the%20same%20file%20as%20shown%20in%20the%20following%20screenshot%3A%3C%2FP%3E%3
Ayman Hassan

Hello all,

Does PowerQuery for Excel has the option to stop loading some queries?

I Collect data from multiple sources and then append them to one query, then when I load the data all the queries and tables are loaded, the original and the appended tables, this results in data duplication in reports. I found an option in Power BI to enable or disable loading data for selected queries in the same file as shown in the following screenshot:






Where can I find this option in Power Query for Excel or how can I solve this problem when I append multiple queries in Excel?


2 Replies

@Ayman Hassan 


In Excel, they are all loaded by default, but you can, and probably should, change this.

  1. Launch Power Query
  2. Go to File, Options
  3. Go to the Global section
  4. Go to Data Load
  5. Select the Specify custom load settings
  6. Uncheck both.

This will not change existing loads though.

To do this, you change it on a per query basis in Excel, not Power Query.


In Excel, with Power Query closed, go to the Data tab, and select Queries and Connections so the query list pops out in the right hand pane.


Right-click on each query and select Load To..., then...

  • Select connection only - this will not load anywhere, but would be used as a query for use by other queries in Power Query
  • Table - this will load the query into an Excel Table
  • DataModel (checkbox at bottom) this will load the data into the data model for use by PowerPivot or CUBE functions.

There are other options, like loading directly to a Pivot Chart, but  you get the idea.

Note: if you have anything loaded anywhere and you change it, it will potentially delete data. Data in a table for instance will delete the table entirely if you change it to a connection. Data in the datamodel will vanish and trash any measures that rely on it if you uncheck the DataModel box.


I will try and give feedback


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies