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

Options

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×