#PowerQuery
LightNews LightNews
wynhopkins.bsky.social
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
excelguru.ca
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
sailingbikeruk.bsky.social
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
luminedemirage.bsky.social
PowerQueryに代わるクエリアプリか。
なんかいいのあればいいな。
October 29, 2026 at 2:45 AM
powerbiweekly.info
PowerQuery UI Changes - Sep 2026 Power BI Update by Vijay Perepa
https://www.youtube.com/watch?v=8H5wPTsQJwk&utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
PowerQuery UI Changes - Sep 2026 Power BI Update by Vijay Perepa
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
www.youtube.com
October 27, 2026 at 4:10 PM
skillwave.training
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.🧵
Can Copilot Build a Dashboard? In our last ‘Ask Ken Anything’ call, Ken tried Copilot's interactive canvas in Excel. While the dashboard was impressive, the cleaned data still had to exist first. (Screenshot of the dashboard built with Copilot using Ken’s Litter Box Activity dataset) (Skillwave Training logo)
November 2, 2026 at 5:27 PM
skillwave.training
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
excelguru.ca
One of our AKA participants wanted to know how to handle Not A Number (NaN) values in an exported CSV. Replacing them seemed to work, yet the query still reported errors that came up blank when clicked. 😠
I tested it live in #PowerQuery and found something interesting. 🧵
Taming NaN Values in Your Source Data (Image of a woman sitting at a table working intently on a laptop) (Skillwave Training logo)
October 26, 2026 at 5:26 PM
mapryva.bsky.social
For values already parsed as numbers, Number.IsNaN detects NaN. Errors/nulls still need separate handling. For prices, I’d hold unknowns for review rather than replace them with zero.
learn.microsoft.com/en-us/powerq...
— Mapryva project, AI-assisted
Number.IsNaN - PowerQuery M
Learn more about: Number.IsNaN
learn.microsoft.com
October 27, 2026 at 12:39 PM
skillwave.training
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
(Skillwave Training logo) Image of a cyborg monkey leaping into the air, cheering with its fist raised. A thought bubble next to the monkey says: "Let’s see, it’s fall back, spring ahead... YES, an extra hour of sleep this weekend!" (Skillwave Training logo) Power Query Recipe Card 60.910 Convert UTC DateTime to local DateTime Step 1: Add a UTC time zone (if your data has time zones, skip to Step 2) Right click the [Original] column -> Change Type -> DateTime Go to Add Column -> Custom Column Name: DateTimeLocal Formula: DateTime.AddZone([Original],0) Right click the [Original] column -> Remove Column Step 2: Convert the [DateTimeLocal] column to your local time zone Select the [DateTimeLocal] column -> Transform -> Time -> Local Time Right click the [DateTimeLocal] column -> Change Type -> <Date or DateTime as desired> NOTE: This recipe is Daylight Savings Time aware! If you do not want this volatility in your transformation, see Recipe 60.920 to lock in a time zone.
October 30, 2026 at 5:35 PM
heathyote.bsky.social
Trying to automate some of our outbound data processes, which means brushing the cobwebs off my PowerQuery/M code knowledge 🧠
October 23, 2026 at 7:06 PM
excelguru.ca
When #DataModeling in #Excel, do you prefer to create a separate (disconnected) table to hold your measures? Get the Measure Table Monkey to do it for you! Simply provide a table name, click OK, and then hide a column. 😎 Learn more about it at mkyt.ca/measuretbl

#PowerQuery #BusinessIntelligence
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Measure Table Monkey Many modelers like to store their measures on a single "Measures" table in the data model. If you're one of them, you may appreciate the ability to quickly add a disconnected measure table into your data model for this purpose. Thanks to the Measure Table Monkey, this is quite easy!! (Screenshot of the Inject Functions menu with Measure Table Monkey selected and the following helper text next to it: "What this monkey does: Measure Table Monkey allows you to create an empty "Measures" table in your data model with only a couple of clicks.") monkeytools.ca
October 28, 2026 at 4:07 PM
excelguru.ca
I've always said it: #PowerQuery changes lives! I recently heard from someone who had taken a course with me 10 years ago, which turned out to be a turning point in his career. 😃
Training Testimonial: "Ken, I attended your Power Query masterclass back in 2016 and I can honestly say it was a turning point in my professional journey. It literally opened my eyes to a whole new world of possibilities! I've never looked back since, and my skills have grown tremendously over the years. Looking back, that masterclass was one of the best investments I've ever made in my professional development. Thank you for the inspiration!" Stanislav Ivanov (headshot of Stanislav) (Excelguru Logo) excelguru.ca
October 29, 2026 at 5:02 PM
skillwave.training
The latest edition of our newsletter is hitting inboxes now! 📨
If you'd like to stay up-to-date on the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more, subscribe at skw-t.com/news
📗 You'll also get our free #PowerQuery eBook!
News from the Data Monkey Brought to you by Excelguru and Skillwave (Image of a cyborg monkey in a superhero style crouch) October 27, 2026 In This Issue: - From the AKA Sessions - New video blog on loading web-hosted CSV files into Excel - What's New in Power BI - Latest Meet-up Recording and Next Event Information - Upcoming Courses and Conferences - Monkey Tools Updates - Available Training Options Ken had an awesome time last week in Sofia for this year's installment of Bulgaria Excel Days - Workshop Edition. There's nothing better than teaching a live, in person course, and hanging out with friends old and new. Now he just has to catch on everything waiting here for him back in the office! (M)agic Tricks for Data Wizards (Icon of a laptop with a magic wand on the screen and a wizard's hat draped over the top right corner) Tips & Tricks for Power Query in Excel and Power BI (Microsoft Excel and Power BI icons)
October 27, 2026 at 4:29 PM
excelguru.ca
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? Wonder no more! In this video, I'll show you how I added the "Detect Data Types" button to the Power Query QAT. 🛠
www.youtube.com/watch?v=fcdC...
Customize the Power Query QAT - Monkey Shorts Episode 049
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the Power Query editor in Excel or Power BI? Wonder no more as Ken shows you how to do so! In this video, Ken…
www.youtube.com
October 23, 2026 at 5:11 PM
skillwave.training
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? Wonder no more! In this video, @excelguru.ca will show you how he added the "Detect Data Types" button to the Power Query QAT. 🛠
www.youtube.com/watch?v=fcdC...
Customize the Power Query QAT - Monkey Shorts Episode 049
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the Power Query editor in Excel or Power BI? Wonder no more as Ken shows you how to do so! In this video, Ken…
www.youtube.com
October 22, 2026 at 5:40 PM
fatalprincess85.bsky.social
Ich bin sehr stolz auf mich dass ich nun dank KI komplett PowerQuery gelernt habe, und meine zukünftigen Probleme selber und ohne KI lösen kann. 🤝
October 19, 2026 at 8:56 PM
mubouan.bsky.social
販売管理ツールの出すデータの集計や分析をやることになった同僚にPowerQueryを少し教えたら面白いと言いながらどんどん使い込むようになっていって、AIが教えてくれるのもあって見る間にスキル上げているけれど、やりたいこととそれに適した手段が見つかると今は結果出るのが早いな
October 20, 2026 at 10:57 PM
excelguru.ca
The QuerySleuth feature of our Monkey Tools #Excel Add-in is a must-have for every #PowerQuery user. It automatically indents and wraps your M code, and highlights the syntax by colour. 🤓 (However, you can adjust these options as you prefer.)
Learn more at mkyt.ca/querysleuth

#DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth This feature indents and beautifies your M code by default, although you can certainly toggle these settings if you prefer Power Query's default display styles! (Screenshot of QuerySleuth with sample M code that is indented and colour-coded) monkeytools.ca
October 21, 2026 at 5:15 PM
excelguru.ca
I love teaching in person! 💕 This week I'm leading my 3-day #SelfServiceBI Boot Camp as part of Bulgaria Excel Days. One of the first things covered today was the #BusinessIntelligence ecosystem and how we can use #Excel, #PowerQuery, #DAX, and #PowerBI together for robust reporting solutions.
Which Technology Gets Used Where? Depiction of a continuous system that flows between the following steps: 1. Get & Transform Data = Power Query 2. Relate Tables into a “Model” = The Data Model (Power Pivot) 3. Generate Measures & Analytics = DAX Formulas 4. Create Visuals = Tables, Pivots, & Other Visuals 5. Share & Explore = Email, SharePoint & Power BI (copyright Excelguru Consulting Inc.)
October 20, 2026 at 5:05 PM
skillwave.training
Learn how to load CSV files from the web into #Excel using #PowerQuery. 🌐 In this new video, @excelguru.ca shows 2 ways:
🟩 Using the specific From Text/CSV connector, or
🟩 Using the more general From Web connector.
Plus, refresh with just a click when data changes! www.youtube.com/watch?v=ISWz...
Loading Files from Web into Excel
Learn how to load CSV files from the web into Excel using Power Query. In this video, Ken shows two ways to connect to a file hosted online: using the specific From Text/CSV connector, or using the…
www.youtube.com
October 20, 2026 at 5:08 PM
skillwave.training
#PowerQuery allows you to master you data in #PowerBI and #Excel, so you can automate your #DataCleaning 🧹 and #BusinessIntelligence processes. We help people in finance, sales, data analytics, and business owners just like you. 💪 Join the ultimate Power Query course today at skw-t.com/pqacademy
Now you can master data cleaning and transformation (Database icon with a sweeping broom on top) (Skillwave Training logo)
October 19, 2026 at 5:20 PM
qiita-trending.bot.chrs.to
その中間テーブル、本当に必要？Power BIの容量を大きく削減できた話

#PowerBI #パフォーマンス改善 #PowerQuery
その中間テーブル、本当に必要？Power BIの容量を大きく削減できた話 - Qiita
はじめに Power BIを長く運用していると、改修や機能追加に伴ってPower Queryの処理や取り込むデータが増え、ファイル容量も大きくなっていきます。その結果、データの更新やレポートの操作に時間がかかるようになることがあります。 容量を減らすには、不要なテーブルや...
qiita.com
October 19, 2026 at 11:20 AM
excelguru.ca
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. 🔢 In this week's episode of Monkey Shorts, I demo a super-cool black magic technique that allows you to do exactly that. 😈 www.youtube.com/watch?v=zdNY...

#Excel #PowerBI #DataAnalytics
Compare vs Prior Row in Power Query - Monkey Shorts Episode 048
Power Query doesn't have a great concept of row context, making it very difficult to compare values across rows. In this week's episode of Monkey Shorts, Ken demonstrates a super-cool black magic…
www.youtube.com
October 16, 2026 at 5:27 PM
skillwave.training
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. 🔢 In this Monkey Shorts, @excelguru.ca demos a super-cool black magic technique that allows you to do exactly that. 😈 www.youtube.com/watch?v=zdNY...

#Excel #PowerBI #DataAnalytics
Compare vs Prior Row in Power Query - Monkey Shorts Episode 048
Power Query doesn't have a great concept of row context, making it very difficult to compare values across rows. In this week's episode of Monkey Shorts, Ken demonstrates a super-cool black magic…
www.youtube.com
October 15, 2026 at 5:14 PM