Clear Excel Cache Office 2010 Download In The

Power Query will then treat this date 1102017 as October 1st, 2017 and not as January 10th, 2017.

So lets have a look on few recommendations which can save you lots of pain in future.

This articles covers only the most relevant settings (not all).

Settings not covered in this articles are usually self-explanatory.

If you have e. g.

This is most of the time unnecessary since only few queries are the important ones which need to be exported to Excel.

Find Show Queries depending in your Excel version and then follow these steps.

Cleaning your Power Query cache when something is not working as expected can be as useful as restarting your PC.

So how do you clean your Power Query cache Again, navigate to GLOBALData Load.

In the background, you are forcing Power Query to reload all the information.

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.

The solution is to clear cache and you queries will run smoothly again.

Sometimes, its just easier to edit the code by simple typing into code in the formula bar than re-doing a step again when changes are needed.

The trouble is that there is no Back button, so when you broke the code of that step, you will need to remove the step (not entire query) and do it again.

It takes a while to get used to monospaced font but I found it useful.

Basically, this option will prevent LOTS of error messages from appearing.

They would usually come up when combining data from various data sources.

Clear Excel Cache Office 2010 Download In The

You can tick or untick Allow data preview to download in the background.

Your PC will probably run at 100 CPU and Power Query will consume 50 you RAM.

It may get to the point that your PC will be slow to respond.

The quick fix is to untick this option so Power Query only loads the necessary data for the current query.

The downside will be that Power Query will be slower BUT it will operate reliably.

You can set Regional Settings which affect how Power Query manipulates dates, currencies and other features specific to regions countries.

So e. g. when you live in Czech Republic, you can choose Czech (Czech Republic).