#powerquery
Why you should aggregate the data in Power BI #data #dataanalytics #powerbi #powerquery #datareduction
November 13, 2026 at 8:02 AM
Mostly the ETL part with PowerQuery. Afaik, there is no good substitute well integrated with a spreadsheet. Most people in my courses are delighted with it and see its advantages, and wouldn't really consider learning SQL to perform most of the tasks. What non-MS workflow would you suggest?
November 14, 2026 at 7:28 AM
For one of our ‘Ask Ken Anything’ (AKA) calls, a student sent in a real puzzler. 🧩 A CSV file was loaded into #PowerQuery, and where one line of data showed up on two separate lines in the same cell.
@excelguru traced it to a single description cell where someone had pressed Enter while typing.🧵
November 11, 2026 at 5:24 PM
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #PivotTable? ☹️ In this episode of Monkey Shorts, @excelguru.ca will show you how to fix this issue. 🙂
www.youtube.com/watch?v=gTtt...

#Excel #DataAnalytics #ExcelTipsAndTricks
One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002
Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.
www.youtube.com
November 12, 2026 at 5:36 PM
毎年更新するマスタを、PowerQueryで取り込むように変更してみたけれど……さて?
過去データ消しちゃったから、明確な動作確認がちょっとできていないんだけれど、まあいっか……。
November 10, 2026 at 8:53 AM
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #PivotTable? ☹️ In this episode of Monkey Shorts, I'll show you how to fix this issue. 🙂
www.youtube.com/watch?v=gTtt...

#Excel #DataAnalytics #ExcelTipsAndTricks
One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002
Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.
www.youtube.com
November 13, 2026 at 4:12 PM
Want to catch up about all things #PowerQuery? Check out the new #PowerQueryCorner launched by one of out founders, Miguel Escobar. You’ll find tips on the latest features, and a summary of where his team is at with the new UI in #PowerBI Desktop: community.fabric.microsoft.com/blog/fbc_pbi...
Power Query Corner: Finding and connecting to data in the new experience (Preview) | Microsoft Fabric Community
About this series This is the first in a six-part Power Query Corner series exploring the new Power Query experience. Each post takes a closer look at a...
community.fabric.microsoft.com
November 13, 2026 at 5:13 PM
During an AKA session, we revisited a favorite data set: automated litter box records, where one cat caused more than 1,000 interrupted clean cycles in a single month. 🐱
In 2023, finding the culprit took serious #PowerQuery work, followed by manual creation of #PivotCharts linked with slicers. 🧵
November 12, 2026 at 6:07 PM
Are your UTC transaction dates showing up on the wrong day in your reports? 📆🕛
In this step-by-step tutorial, @excelguru.ca demonstrates how to convert UTC timestamps into local dates using #PowerQuery in #Excel or #PowerBI, while accounting for daylight saving time: www.youtube.com/watch?v=qh3C...
Convert UTC Date Time to Local Date Using Power Query
Are your UTC transaction dates showing up on the wrong day in your reports? When working with data across different time zones, simply changing a Date/Time column to Date may produce incorrect…
www.youtube.com
November 9, 2026 at 5:28 PM
I'm leading a great day of #PowerQuery training for Chartered Professional Accountants of BC. If you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊

#Excel #PowerBI
November 10, 2026 at 5:14 PM
On the first Monkey Shorts episode, I showed the first #PowerQuery setting I change when I install #Excel - the query load destination. 🐵🩳 www.youtube.com/watch?v=ZAY7...

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools
Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
www.youtube.com
November 6, 2026 at 5:09 PM
On the first Monkey Shorts episode, @excelguru.ca showed the first #PowerQuery setting he changes when he installs #Excel - the query load destination. 🐵🩳 www.youtube.com/watch?v=ZAY7...

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools
Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
www.youtube.com
November 5, 2026 at 5:26 PM
Excel is in OneDrive, but Power BI still asks for a gateway? Check the path: it may be reading your local synced copy.

I show how to use the cloud URL, plus what changes in the new Power Query experience.

youtu.be/-zc0JmPIu3c

#PowerBI #PowerQuery #Excel #SharePoint
Excel is in OneDrive, but why Power BI Still Wants a Gateway?
YouTube video by BI Insight
youtu.be
November 5, 2026 at 10:44 PM
Students love our FREE #PowerQuery intro course! 💖
Power Query allows you to gather and transform data for building refresh-able #BusinessIntelligence solutions. Learn the fundamentals in #Excel and #PowerBI by joining today at skw-t.com/pqfun

#DataPreparation #DataAnalytics
November 6, 2026 at 5:09 PM
Stop trying to figure it all out on your own - we've got you covered! 👊 Join Skillwave today and unlock the full potential of #PowerBI, #PowerQuery, #PowerPivot, and #Excel.
Our #DataAnalytics and #BusinessIntelligence courses are designed by leading experts. 💻 View catalog at skw-t.com/courses
November 4, 2026 at 5:10 PM
Often, the reason for tracing a query’s dependency chain is to make a change to a child query, and you want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right within the editor, without opening #PowerQuery! 🤯 Learn more at mkyt.ca/querysleuth

#Excel
November 4, 2026 at 4:48 PM
Are your UTC transaction dates showing up on the wrong day in your reports? 📆🕛 In this step-by-step tutorial, I demonstrate how to convert UTC timestamps into local dates using #PowerQuery, while accounting for daylight saving time (DST): youtu.be/qh3CgSXAszs

#Excel #PowerBI #DataAnalysis
https://youtu.be/qh3CgSXAszs
youtu.be
November 2, 2026 at 5:46 PM
Wow - a former student emailed out of the blue the other day to share a success story. 🤩 #PowerQuery for the win!
November 3, 2026 at 4:42 PM
During last week's AKA, @excelguru.ca revisited a favorite data set: automated litter box records, where one cat caused more than 1,000 interrupted clean cycles in a single month. 🐱
In 2023, finding the culprit took serious #PowerQuery work plus manual creation of #PivotCharts linked with slicers.🧵
November 2, 2026 at 5:27 PM
Copliot generating M queries in Excel….

Things are moving fast!

#Excel #PowerQuery #Copilot

How good is Copilot at Power Query ?
youtu.be/72HWA5I9qCg
How good is Copilot at Power Query ?
YouTube video by Access Analytic Learn
youtu.be
October 31, 2026 at 2:37 AM
Anyone using AI to help with Power Query M and DAX? Which models are you having most success with?

I’ve found Claude wanting on a couple of occasions, even to the point it was arguing with me on one occasion?

Any of the open models worth trying?

#PowerQuery #PowerQueryM #DAX
October 31, 2026 at 7:59 PM
PowerQueryに代わるクエリアプリか。
なんかいいのあればいいな。
October 29, 2026 at 2:45 AM
PowerQueryに代わるクエリアプリか。
なんかいいのあればいいな。
October 29, 2026 at 2:45 AM
Don't forget: daylight savings ends in many parts of North America on Sunday, November 1. ☀️ Luckily, our #PowerQuery recipe for converting a UTC DateTime to a Local DateTime is daylight savings aware. Get the full collection: skw-t.com/pqrecipes

#Excel #PowerBI #DataAnalytics #BusinessIntelligence
October 30, 2026 at 5:35 PM
Here, @excelguru.ca does a real-world demo of the 9 #PowerQuery join types. 🤝 We'll walk through how each join behaves when matching data across multiple columns without needing to manually create a combined key: www.youtube.com/watch?v=Cn-3...

💡 This works the same in both #Excel and #PowerBI.
9 Ways to Merge Tables Using Power Query
In this video, we take the 9 Power Query Join types from concept to real-world demo. Using a Transactions table and a Chart of Accounts table, Ken walks through how each join behaves when matching…
www.youtube.com
October 28, 2026 at 5:43 PM