How to change the Loading Destination of a Power Query query in Excel

Опубликовано: 19 Октябрь 2024
на канале: Celia Alves - Solve & Excel

12,145

In Excel, the result of a Power Query query can be loaded to a Table, a Pivot Table, or a Pivot Chart. In addition to one of the previous options, the query results can also be loaded to the Data Model. Or, we can choose not to load it at all ("Only Create Connection.)
Learn how to set "connection only" as the default destination for all new queries: https://solveandexcel.ca/2023/05/31/p...
----------------------
My Contact information:
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca/
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel

--------------------------
Learn Excel and connect with a community of Excel professionals and enthusiasts:
MS Excel Toronto Meetup Group - https://www.meetup.com/MSExcelToronto/

#Excel #solveandexcel #microsoft365 #toronto #torontobusiness #mvpbuz #communityrocks #wit