How to set default Power Query settings

You use the Options dialog box to set Custom Default Load Settings and Cache Management.

Set default Power Query options

  1. In the Power Query ribbon tab, click Options.

  2. In the Options dialog box, you can

    • Set default query load settings

    • Configure data cache management option

    • Enable Power Query tracing

    • Restore Power Query defaults


Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.