This is either error in Power Query OR in Google Sheets. Quite often, I get “error message” that column XYZ was not found in the connected Google Sheet file while I know that the column is present in the Google Sheet file. This is particularly useful when working with large Google Sheet files connected as Excel files. In the background, you are forcing Power Query to reload all the information. The bottom part of the window is related to cache. So how do you clean your Power Query cache? Again, navigate to GLOBAL>Data Load. Cleaning your Power Query cache when something is not working as expected can be as useful as restarting your PC. Here is the sequence of loading and “unloading”:

Sometimes, you will need to “unload” or get rid of some of the the loaded queries which were loaded to Excel by accident. Find “Show Queries” depending in your Excel version and then follow these steps: When you are already in standard Excel, you can also load results of your queries from there. When your are in Power Query, follow these steps: How to load queries to Excel manually? There few options. I am unticking “Load to worksheet” and “Load to Data Model” and I am only loading selected queries to Excel sheet manually. As a result, I started to use this setup: This is most of the time unnecessary since only few queries are the important ones which need to be exported to Excel. 50 queries, they would be loaded to 50 separate Excel sheets. By default, all the query will be loaded to your standard Excel sheets when you close Power Query window. “CURRENT WORKBOOK” settings will affect only the current Excel fileĪs you can see, “GLOBAL” settings are covering more areas (Data Load, Query Editor, Security, Privacy, Account, Diagnostics) than “CURRENT WORKBOOK” (Data Load, Regional Settings, Privacy).ĭata Load settings affect how the queries are loaded.“GLOBAL” settings will affect ALL the projects you create in Power Query.It is important to distinguish between Global and Current Workbook settings: Settings not covered in this articles are usually self-explanatory.įOLLOW US GO TO STORE How to Navigate to Power Query SettingsĪ new settings window will load. This articles covers only the most relevant settings (not all). So let’s have a look on few recommendations which can save you lots of pain in future. One should never underestimate settings in Power Query.

Power query excel 2019