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
Most People Merge #excel Files Wrong ❌ Here’s a Smarter Way ✅ by Chandeep Chhabra #PowerQuery #PowerBI www.youtube.com/watch?v=WoYC...
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
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
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
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.
🎉 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...
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
🎉 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...
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...
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
Here's the workaround
YouTube: youtu.be/w0_st7-Fw0I&...
#Excel #PowerQuery
January 8, 2026 at 7:37 AM
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
Here's the workaround
YouTube: youtu.be/w0_st7-Fw0I&...
#Excel #PowerQuery
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
#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
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
#BusinessIntelligence
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/
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
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/
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/
7 Tiny Fixes That Instantly Improve Your Dashboards by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=i0C5...
7 Tiny Fixes That Instantly Improve Your Dashboards
Join Goodly Insider today and get 20% off with the Black Friday offer, plus extended access + monthly live sessions, and Monkey Tools Pro - https://products....
www.youtube.com
November 25, 2025 at 2:10 PM
7 Tiny Fixes That Instantly Improve Your Dashboards by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=i0C5...
The 8 Biggest Mistakes Behind 80% of Report Problems by Chandeep Chhabra #PowerQuery #businessintelligence #excel #PowerBI www.youtube.com/watch?v=Tw7D...
The 8 Biggest Mistakes Behind 80% of Report Problems
https://youtu.be/yw0QHu9V4UQ?si=l4R_qJCZlnYP87nwIn this video, I share the most common (and often stupid) mistakes I keep making in Power BI and how you can ...
www.youtube.com
September 26, 2025 at 3:20 AM
The 8 Biggest Mistakes Behind 80% of Report Problems by Chandeep Chhabra #PowerQuery #businessintelligence #excel #PowerBI www.youtube.com/watch?v=Tw7D...
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
#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
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
#Excel #PowerBI #DataCleaning #DataAnalysis
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
#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
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
#Excel #PowerBI #DataPreparation
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! 🚀
Both #PowerQuery and Formulas have lazy evaluation.
It's a fantastic, reactive, functional programming environment! 🚀
Alright #databs time for a trial run
What one type of technology would you consider the heart and soul of your data stack?
What one type of technology would you consider the heart and soul of your data stack?
November 7, 2024 at 5:39 AM
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! 🚀
Both #PowerQuery and Formulas have lazy evaluation.
It's a fantastic, reactive, functional programming environment! 🚀
Understanding Semi Joins in #PowerQuery M by Rick de Groot #PowerBI https://gorilla.bi/power-query/understanding-semi-joins/?utm_source=bluesky&utm_medium=social&utm_campaign=powerbiweekly
Understanding Semi Joins in Power Query M - BI Gorilla
Learn how to use the Left and Right Semi Join allow to filter a table to return only those rows that exist in another table.
gorilla.bi
September 11, 2024 at 9:50 PM
Understanding Semi Joins in #PowerQuery M by Rick de Groot #PowerBI https://gorilla.bi/power-query/understanding-semi-joins/?utm_source=bluesky&utm_medium=social&utm_campaign=powerbiweekly
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
https://youtu.be/tegvFYOn-sI
November 18, 2024 at 9:11 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
https://youtu.be/tegvFYOn-sI
The things I would do for bulk editing activities across multiple queries... #PowerQuery
November 17, 2024 at 9:16 PM
The things I would do for bulk editing activities across multiple queries... #PowerQuery
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
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
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
https://docs.microsoft.com/en-us/powerquery-m/table-removematchingrows
Today's #PowerQuery "M"agic of the day brought to you by 404 error handling with Web.Contents().
https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
Chris Webb's BI Blog: Handling 404–Not Found Errors With ...
One strange feature of the Web.Contents() function in Pow...
blog.crossjoin.co.uk
November 18, 2024 at 1:46 AM
Today's #PowerQuery "M"agic of the day brought to you by 404 error handling with Web.Contents().
https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
Quit scrolling and jump in now! #PowerQuery #PowerBI #Excel
https://www.meetup.com/Portland-Power-BI-User-Group/events/282293830/
https://www.meetup.com/Portland-Power-BI-User-Group/events/282293830/
403 Forbidden
www.meetup.com
November 17, 2024 at 9:51 PM
Quit scrolling and jump in now! #PowerQuery #PowerBI #Excel
https://www.meetup.com/Portland-Power-BI-User-Group/events/282293830/
https://www.meetup.com/Portland-Power-BI-User-Group/events/282293830/
Today's lifesaving function is Cube.Dimensions() - https://docs.microsoft.com/en-us/powerquery-m/cube-dimensions
#PowerQueryEverything
#PowerQueryEverything
Cube.Dimensions - PowerQuery M
Learn more about: Cube.Dimensions
docs.microsoft.com
November 17, 2024 at 9:16 PM
Today's lifesaving function is Cube.Dimensions() - https://docs.microsoft.com/en-us/powerquery-m/cube-dimensions
#PowerQueryEverything
#PowerQueryEverything
#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/
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
#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/
https://powerquery.microsoft.com/en-us/blog/new-certified-connectors-available-in-power-bi-dataflows-and-datamarts/
Loving how many people are learning about #PowerQuery parameters to limit/test rows today! Awesome stuff @parvchana !!!
November 17, 2024 at 7:07 PM
Loving how many people are learning about #PowerQuery parameters to limit/test rows today! Awesome stuff @parvchana !!!
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/
"#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
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/
"#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/
Power BI Data Management Gateway 1.2 Changes the Game - http://whitepages.unlimitedviz.com/2014/08/power-bi-data-management-gateway-1-2-changes-the-game/ . #PowerQuery is now the focus #PowerBI #Office365
Power BI Data Management Gateway 1.2 Changes the Game
whitepages.unlimitedviz.com
December 5, 2024 at 11:10 PM
Power BI Data Management Gateway 1.2 Changes the Game - http://whitepages.unlimitedviz.com/2014/08/power-bi-data-management-gateway-1-2-changes-the-game/ . #PowerQuery is now the focus #PowerBI #Office365
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
Now if they can just import powerquery and formula debugging and python mode and
October 21, 2024 at 7:04 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
Now if they can just import powerquery and formula debugging and python mode and