powerquery Archives - Struggling To Excel

Have you ever blocked Power Query from downloading OneDrive Files Automatically?

By Ejaz September 9, 2026Tips and TricksNo Comments

When you have files-on-demand activated on OneDrive, only a placeholder exists for a file until you use it. And when an app tries to access it, OneDrive downloads the file…

Create Spreadsheet Processes Like a Rockstar

By Ejaz April 3, 2025Tips and Tricks

You will do three kinds of tasks in any process based on how much of your attention it demands. You do not need any fancy AI techniques to start adding…

Frustrated with Missing Columns in PowerQuery? Handle it like a Pro

By Ejaz December 3, 2024PowerQuery

Have you ever had to deal with missing columns in your data?Happens especially when you pivot over a column (go tall-to-wide). Most of the time, you end up with all…