Most people use Power Query with the default settings and never think twice about it. But changing just 7 settings can dramatically improve performance, save you from common headaches, and make the whole experience smoother.
In this video, I'll walk you through each setting, where to find it, why the default is a problem, and what to change it to.
These settings apply to Power Query in Excel. Some also apply to Power BI, but this video focuses specifically on Excel.
Settings covered in this video:
00:00 Intro
00:21 - How to access Query Options
01:56 - Setting 1: Default Load Settings (Connection Only)
03:40 - Setting 2: Type Detection (Stop Auto-Detecting Column Types)
05:28 - Setting 3: Fast Data Load
06:36 - Setting 4: Background Data Preview Download
07:35 - Setting 5: Column Distribution and Column Profile
10:13 - Setting 6: Refresh Data When Opening File
10:58 - Setting 7: Disable Background Refresh (Fix the Pivot Table Problem)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://trumpexcel.com/excel-vba-course/
✅ Free Power Query Course - https://trumpexcel.com/power-query-course/
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal
