#PowerQuery
Most People Merge #excel Files Wrong ❌ Here’s a Smarter Way ✅ by Chandeep Chhabra #PowerQuery #PowerBI www.youtube.com/watch?v=WoYC...
Most People Merge Excel Files Wrong ❌ Here’s a Smarter Way ✅
Download the Practice Kit ⬇️ - https://goodly.co.in/combining-data-from-multiple-excel-files/Register for the Power BI Foundations Workshop - https://goodly....
www.youtube.com
February 6, 2026 at 6:30 AM
I used copilot for some really simple powerquery code, and it failed initially because I assumed it would know to do things that I would know to do when writing the code, but a dumb intern or, like, extremely literal computer, did not
February 5, 2026 at 4:37 AM
someday someone will invent the truest pure milsim video game. it will be implemented in Microsoft Excel using PowerQuery across eight spreadsheets. it will bring most computers to its knees. the top player on the leaderboard will be a bored teenager from east ukraine.
January 28, 2026 at 1:38 AM
🎉 It's awesome to see that #PowerQuery is now generally available in #Excel for Web, including the PQ Editor and import wizard!

Learn more about all of the latest updates to Excel for Windows, Web, and Mac in this blog post from the Excel team: techcommunity.microsoft.com/blog/excelbl...
What's New in Excel (January 2026) | Microsoft Community Hub
Happy New Year, and welcome to the January 2026 update! We’re excited to share that Agent Mode in Excel is now generally available in Excel on Windows and is...
techcommunity.microsoft.com
January 28, 2026 at 6:27 PM
The New Excel for Web Power Query interface is currently missing the From Table/Range option...

Here's the workaround

YouTube: youtu.be/w0_st7-Fw0I&...

#Excel #PowerQuery
January 8, 2026 at 7:37 AM
When notes are added to a table generated by #PowerQuery in #Excel, refreshing the data can cause those notes to shift and no longer align with the correct records. In this video, @excelguru.ca explains why this happens and how to fix it: www.youtube.com/watch?v=Hg1x...

#BusinessIntelligence
Tracking Notes
Join Ken Puls in this episode as he addresses a common challenge raised during a Self-Service Business Intelligence Academy, Ask Ken Anything session. When notes are added to a table generated by…
www.youtube.com
January 7, 2026 at 5:31 PM
Your #PowerBI issues aren’t about data.
They’re about hidden logic.

#DAX, #SQL and #PowerQuery become too complex for teams to trace.
When no one understands how numbers are built, trust collapses.

Discovery AI fixes this: www.powerbisentinel.com/discovery-ai/
December 10, 2025 at 11:01 AM
By default, when you unpivot a set of data in #PowerQuery, all null records are suppressed. But what if you need them in your unpivoted data set? 🤷 Here, I'll show you 2 different methods and discuss the impacts of each: www.youtube.com/watch?v=-j_q...

#Excel #PowerBI #DataCleaning #DataAnalysis
Keep null Values During UnPivot Operations - Monkey Shorts Episode 043
By default, when you unpivot a set of data in Power Query, all null records are suppressed. But what if you need them in your unpivoted data set? In this week's episode of Monkey Shorts, Ken shows…
www.youtube.com
September 26, 2025 at 4:46 PM
In this video, I demonstrate how to use #PowerQuery to perform approximate matching when working with multiple criteria. Inspired by a student question, I'll walk through the solution using a fictitious employee salary dataset: www.youtube.com/watch?v=ZZC7...

#Excel #PowerBI #DataPreparation
Approximate Match Based on Multiple Columns (Power Query)
In this video, Ken demonstrates how to use Power Query to perform approximate matching when working with multiple criteria. Inspired by a question from a Skillwave course attendee in the Discussion…
www.youtube.com
January 12, 2026 at 6:31 PM
It's time for devs to take a look at modern #Excel! It now has all the core #FunctionalProgramming constructs: LAMBDA, LET, MAP, REDUCE, SCAN, … as well as GROUPBY, PIVOTBY, …

Both #PowerQuery and Formulas have lazy evaluation.

It's a fantastic, reactive, functional programming environment! 🚀
The only answer is Excel
#databs #datasky
Alright #databs time for a trial run

What one type of technology would you consider the heart and soul of your data stack?
November 7, 2024 at 5:39 AM
#PowerQuery Fail?

When Clean does not work...

youtu.be/61qnHOcXvLs&...

#Excel #PowerBI
February 19, 2025 at 11:16 AM
I guess the good part about being stuck inside as #MardiGras descends on my neighborhood is that I'm just going to knock out some content. Expect more videos to continue to trickle out as I work through my agenda for "An Introduction to #PowerQuery M"

https://youtu.be/tegvFYOn-sI
November 18, 2024 at 9:11 AM
The things I would do for bulk editing activities across multiple queries... #PowerQuery
November 17, 2024 at 9:16 PM
Today's #PowerQuery love is brought to you by Table.RemoveMatchingRows() - is there anything this language can't do?... thank you @MSPowerQuery

https://docs.microsoft.com/en-us/powerquery-m/table-removematchingrows
Table.RemoveMatchingRows - PowerQuery M
Learn more about: Table.RemoveMatchingRows
docs.microsoft.com
November 18, 2024 at 2:16 AM
403 Forbidden
www.meetup.com
November 17, 2024 at 9:51 PM
Cube.Dimensions - PowerQuery M
Learn more about: Cube.Dimensions
docs.microsoft.com
November 17, 2024 at 9:16 PM
#PowerQueryashtag/PowerQueryEverything" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link">#PowerQueryEverything !!! With more and more connectors now available in #PowerBI and #PowerQuery online!

https://powerquery.microsoft.com/en-us/blog/new-certified-connectors-available-in-power-bi-dataflows-and-datamarts/
What is Power Query? - Power Query
Learn what Power Query is, and how it can help you get an...
powerquery.microsoft.com
November 17, 2024 at 9:16 PM
Loving how many people are learning about #PowerQuery parameters to limit/test rows today! Awesome stuff @parvchana !!!
November 17, 2024 at 7:07 PM
PowerQuery Puzzle solved with R

"#163–164PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #163Some puzzle we receive are based on reco..."

https://www.r-bloggers.com/2024/03/powerquery-puzzle-solved-with-r-16/
March 12, 2024 at 3:59 PM
Power BI Data Management Gateway 1.2 Changes the Game
whitepages.unlimitedviz.com
December 5, 2024 at 11:10 PM
Google sheets has tables now, that's cool. That was probably the biggest (though far from only) things Excel had over sheets.

Now if they can just import powerquery and formula debugging and python mode and
October 21, 2024 at 7:04 PM