#powerquery
LightNews LightNews
excelguru.ca
I wrapped up the week with a great day of #PowerQuery training for CPABC.
One of the best things about PQ is that 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! 🔄📊
Power Query Update Options Individual Files Path 1: Save the new data file with a new name -> Open the Workbook -> Edit the Query -> Update the Source path to the new file -> Close the Power Query Editor -> Click Refresh -> Update Visuals (icons for PivotTable, bar chart, line chart, and pie chart) Path 2: Save the new data file over the original -> Open the Workbook -> Click Refresh (refresh icon) -> Update Visuals (icons for PivotTable, bar chart, line chart, and pie chart) The Benefits: Re-use your existing business intelligence reports and logic
November 7, 2025 at 11:44 PM
gregorjclark.bsky.social
If we want to get super-geeky, we use a NativeSQL PowerQuery to send a driver file from spreadsheet (imported from csv), T-SQL query against the Azure Db then bring the results back into Excel before the top bosses ask us to paste a picture of the results into PowerPoint as jpeg then Save As pdf
November 7, 2025 at 11:16 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, as I'll show you how! Check out how I added the "Detect Data Types" button to the Power Query QAT:
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
November 7, 2025 at 5:11 PM
hryggrbyr.fedia.social.ap.brid.gy
Call me daft but I thought there might be an easy way to reference Excel cells in powerquery as they're both Microsoft products but ​:shrug:​
November 7, 2025 at 4:05 PM
guidoleenders.emp.invantive.com
Moest je ff plagen. “We halen de helft van de stappen weg uit de PowerQuery; dan is ie lekker efficiënt”
November 6, 2025 at 8:56 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, as @excelguru.ca shows you how to do so! Check out how he added the "Detect Data Types" button to the Power Query QAT:
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
November 6, 2025 at 5:24 PM
wynhopkins.bsky.social
Stuff all the AI announcements. This is the best news so far...

From SharePoint Folder is now available regardless of which subscription plan. Business Premium users rejoice!

Looks like a few other connectors have lit up too!

If you're on an M365 plan then check it out now

#Excel #PowerQuery
November 6, 2025 at 12:51 AM
excelguru.ca
When you first open Query Sleuth in our Monkey Tools #Excel Add-in, you’ll notice that your queries are colour coded with up to four different colours: 🟠🟡🔵🟢 This adds a bit of extra insight around the query load destinations. Learn more at mkyt.ca/querysleuth

#PowerQuery #DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Query Sleuth Queries are colour coded to add a bit of extra insight. By default: - Yellow = Query is loaded as a "Connection Only" - Green = Query is loaded to the data model - Blue = Query is loaded to an Excel table - Orange = Query is loaded to both the data model and an Excel table (Screenshot of the Query Sleuth dialog with a listing of colour coded queries) monkeytools.ca
November 5, 2025 at 5:16 PM
powerbiweekly.endj.in
How to Scrape Earthquake #Data from PhiVolcs Using ##PowerQuery Part 1 (Taglish) by Dane Belarmino #PowerBI www.youtube.com/watch?v=9jzX...
How to Scrape Earthquake Data from PhiVolcs Using Power Query Part 1 (Taglish)
Learn how to automatically scrape and transform earthquake data from the official PHIVOLCS (Philippine Institute of Volcanology and Seismology) website using...
www.youtube.com
November 5, 2025 at 4:20 PM
rezarad.bsky.social
You can now build the #PowerBI solution from get data and #PowerQuery all the way to #SemanticModel and #report in the web editor without needing to install #PowerBIDesktop

In today's video, I explained this and why this is very helpful for users without Windows machines

youtu.be/5IdkGBU4nDk
Building Power BI report solutions without Power BI Desktop
YouTube video by RADACAD
youtu.be
November 5, 2025 at 5:50 AM
influexcel.bsky.social
PowerQuery no tiene SCAN.  
Tampoco tiene BUSCARX.  
Pero eso no significa que no puedas hacer una clasificación ABC completa. 
Para eso tenemos M. 

¿Clasificación ABC en PowerQuery? Sí, es posible
¿PowerQuery puede hacer una clasificación ABC sin SCAN ni BUSCARX? ¡Sí, es posible! En este tutorial te muestro cómo transformar una tabla de ventas por clie...
youtu.be
November 4, 2025 at 6:03 PM
excelguru.ca
A new student joined my last Ask Ken Anything session with a familiar #Excel headache: “Every month I download new CSVs from our billing system – and every month I spend hours cleaning them up.” 😭

I walked her through how #PowerQuery can automate every step in a single refreshable query.
Goodbye Manual Cleanup, Hello Power Query! (Image of a woman sitting at a desk in front of a laptop with a big grin on her face) (Skillwave Training logo)
November 4, 2025 at 5:06 PM
wynhopkins.bsky.social
Welcome to the #PowerQuery fan club.

I’ve 70+videos that might ease your learning journey

www.youtube.com/playlist?lis...
Power Query - YouTube
How to use Power Query in Excel (and Power BI) to help clean up messy data and connect directly to your files and data sources
www.youtube.com
November 4, 2025 at 1:43 PM
skillwave.training
Don't forget: daylight savings ends in North America on Sunday, November 2. ☀️ Luckily, our #PowerQuery recipe for converting a UTC DateTime to a Local DateTime is daylight savings aware. Get the full recipe collection at skw-t.com/pqrecipes

#Excel #PowerBI #DataAnalytics #DataAnalysisTools
(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) Screenshot of the Power Query Recipe card 60.910.x, which outlines the steps to convert UTC DateTime to local DateTime NOTE: This recipe is Daylight Savings Time aware! If you do not want this volatility in your transformation, see Recipe 60.920.x to lock in a time zone.
October 31, 2025 at 4:20 PM
excelguru.ca
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. In this episode of Monkey Shorts, I'll demonstrate a super-cool black magic technique that allows you to do exactly that.🧙
www.youtube.com/watch?v=zdNY...

#Excel #PowerBI #DataAnalysis
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 31, 2025 at 4:13 PM
powerbiweekly.endj.in
Dynamic Change Tracking for LMS Enrolments Using #PowerQuery M by Parul Rani Sagar #PowerBI community.fabric.microsoft.com/t5/Power-BI-...
Dynamic Change Tracking for LMS Enrolments Using Power Query M
While your Moodle LMS data provides a complete snapshot of daily users, course enrollments, and activity statuses, it obscures the vital story educators, administrators, and analysts really care about:...
community.fabric.microsoft.com
October 30, 2025 at 8:40 PM
powerbiweekly.endj.in
Small #PowerQuery Habits That Change Everything by Chandeep Chhabra #excel #PowerBI www.youtube.com/watch?v=Br8g...
Small Power Query Habits That Change Everything
In this video, I walk through the Power Query best practices that make real projects cleaner and faster. You’ll see how to stage your queries with parameters...
www.youtube.com
October 30, 2025 at 6:30 PM
skillwave.training
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. In this episode of Monkey Shorts, @excelguru.ca demonstrates a super-cool black magic technique that allows you to do exactly that. 🧙
www.youtube.com/watch?v=zdNY...

#Excel #PowerBI
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 30, 2025 at 4:51 PM
amitchandak.bsky.social
New Blog Update- Power BI DAX UDF — User Defined Function- medium.com/@amitchandak...
#PowerBI #MicrosoftFabric #DataAnalytics #BusinessIntelligence #DAX #PowerQuery #MFunctions #DashboardDesign #DataVisualization #AnalyticsTraining #CareerGrowth #LearningJourney
Power BI DAX UDF — User Defined Function
Power BI releases updates monthly, and some of these updates are truly special. And one such long-awaited feature — the DAX User-Defined…
medium.com
October 30, 2025 at 8:36 AM
powerbiweekly.endj.in
Pivot - Get #Data from Name Column Custom Field into Power BI using #PowerQuery by Reza Rad #microsoft #excel #PowerBI www.youtube.com/watch?v=Y6jX...
Pivot - Get Data from Name Column Custom Field into Power BI using Power Query
When the data comes from systems such as CRM and ERP systems, such as Microsoft Dynamics or Salesforce, the custom field capability that exists in those prod...
www.youtube.com
October 30, 2025 at 5:25 AM
powerbiweekly.endj.in
How to Transform & Combine All #excel Sheets in Power BI (No Hardcoding) by Avi Singh #PowerQuery #Data #PowerBI www.youtube.com/watch?v=CL2C...
How to Transform & Combine All Excel Sheets in Power BI 📊 (No Hardcoding!)
📥 Download Free Power BI Resources & Files: https://web.learnpowerbi.com/download📊 Learn Power BI in 30 Days: https://www.LearnPowerBI.com/training🤝 Need ...
www.youtube.com
October 30, 2025 at 3:15 AM
excelguru.ca
The Basic Explicit Measure Monkey provides a simple interface to build basic #DAX measures without writing any code yourself. 😎 It also gives aggregation choices based on your data types, shows the DAX written, and lets you set default measure formats. Learn more: mkyt.ca/bem

#Excel #PowerQuery
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Basic Explicit Measure Monkey This monkey gives you a wizard-like interface to build your DAX measures without code, providing you with aggregations that are valid for your column's data types. It is targeted at those who are new to DAX and need help with getting the syntax right. (Screenshot of the Create Basic Measures interface) monkeytools.ca
October 29, 2025 at 4:11 PM
skillwave.training
The latest edition of our newsletter has just gone out! 📧
If you'd like to stay up-to-date on what's new in #PowerBI, #Excel, and Monkey Tools, content from our experts, and info on specials, events, and courses, subscribe at skw-t.com/news
We'll also send your 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 28, 2025 In this issue: • From the AKA Sessions • Latest Monkey Tools Updates • What's New in Power BI • Recent Meet-up Recording • Upcoming Courses and Conferences • Available Training Options
October 28, 2025 at 5:30 PM
excelguru.ca
Today was the Day 1 of my in-person #SelfServiceBI Boot Camp in Munich. 👨‍🏫 We began with an overview of the #BusinessIntelligence ecosystem, then reviewed #Excel #PivotTables, and wrapped up the day by beginning the dive into #PowerQuery.
Photo of a meeting room set up awaiting the attendees for Day 1 of Ken Puls' Self Service BI Boot Camp in Munich, Germany. There is a long table with chairs around, and a flip chart and screen at the far end of the room. Which Technology Gets Used Where? Image of 5 bubbles indicating the various stages of the business intelligence ecosystem. The bubbles arranged in a circle with arrows pointing from one bubble to the next and labels of which technology is used at each stage: - Get & Transform Data (Power Query) - Relate Tables into a “Model” (Power Pivot Data Model) - Generate Measures & Analytics (PivotTables and Formulas) - Create Visuals (Tables, Pivots, Charts & More...) - Share & Explore (Email, SharePoint & Power BI)
October 27, 2025 at 7:54 PM