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