Latest posts tagged with #PowerQuery on Bluesky
The key idea: Instead of copying worksheets or rebuilding forecasts every week, you:
🟢 Generate your weekly forecast
🟢 Push it through #PowerQuery
🟢 Append it to a history table
🟢 Use that history to analyze how your forecast evolves over time
Why this matters?
(Image of a woman sitting at a long office desk looking intently at her computer monitors with her hand on the mouse.) (Skillwave Training logo) Why is my Power Query Solution So Slow??
A question came up in a recent Ask Ken Anything (AKA) session that many #PowerQuery users will immediately recognize: "I built two versions of a file-combining solution, and one is ridiculously slow - why?" 😭
The student had a folder full of #Excel files and needed to consolidate everything. 🧵
Power Query puede hacer una clasificación ABC automática. Sin columnas auxiliares, sin fórmulas manuales.
Solo con pasos de Power Query: acumulados, rangos y categorías en un flujo limpio y replicable.
👇 Tutorial completo
https://youtu.be/iW6g4rTGOY8
#Excel #PowerQuery #Influexcel
Export Outlook Mailbox to #excel via #PowerQuery by Elle Harrison #PowerBI www.selectdistinct.co.uk/2026/03/31/e...
Solve Tough #Data Problems Beyond Star Schema by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=6X3r...
If you’re seeing this error on your #PowerQuery refresh when loading to Table it’s not just you
Token Refresh Timed Out
#Excel
En Power Query, Number.From ignora tu config regional: siempre interpreta el punto como decimal.
Si mezclas formatos (1.654,67 y 67,765.00), usa Number.FromText con formato explícito para cada caso.
Tip de Rafa en la comunidad de Influexcel
#Excel #PowerQuery #Influexcel
Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! "I loved the direct, clear examples, well separated into what each video will show so I can come back and see it again if I forgot how to do something." Valerie Strafe (5 stars) (Image of a cyborg monkey jumping to up cheer with its eye closed, mouth open, and fist up in the air) Register today at https://mkyt.ca/course
Monkey Tools adds a broad set of features specifically for working with #PowerQuery and the #DataModel. They're divided into 2 general collections:
🐒Monkeys - make things happen
🔎Sleuths - figure out what has happened
In the FREE Using Monkey Tools course, I demo how they work. Go to mkyt.ca/course
![Master Your Data in Excel & Power BI
Pattern Difficulty Scale: No Code
(Image of a cyborg monkey standing with its arms crossed)
Pivoting Stacked Data Recipe
Add a columns for transaction and line IDs
Add Column -> Index Column -> From 0
Select [Index] -> Add Column-> Standard -> Integer-Divide*
Select [Index] -> Transform -> Standard -> Modulo*
Pivot the data
Select [Index] -> Transform -> Pivot Column
Set the Values field to your data column
Open the Advanced option and “Don’t Aggregate”
Right click the [Integer-Division] column -> Remove
Rename the newly created columns
Set your data types
* Modulo and Integer Division always target the number representing the 1st row of the 2nd transaction
(Images of a sample stacked TXT data and the pivoted output table)
For more data patterns check out our courses at www.skillwave.training
Recipe 20.120.2112](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreif5b4ytc5womlmee233vx7t4vdrpoads3e7arelwaxd6bsvrk5j6e)
Master Your Data in Excel & Power BI Pattern Difficulty Scale: No Code (Image of a cyborg monkey standing with its arms crossed) Pivoting Stacked Data Recipe Add a columns for transaction and line IDs Add Column -> Index Column -> From 0 Select [Index] -> Add Column-> Standard -> Integer-Divide* Select [Index] -> Transform -> Standard -> Modulo* Pivot the data Select [Index] -> Transform -> Pivot Column Set the Values field to your data column Open the Advanced option and “Don’t Aggregate” Right click the [Integer-Division] column -> Remove Rename the newly created columns Set your data types * Modulo and Integer Division always target the number representing the 1st row of the 2nd transaction (Images of a sample stacked TXT data and the pivoted output table) For more data patterns check out our courses at www.skillwave.training Recipe 20.120.2112
Say you have a table or TXT file where all the data is in a single column, but you need a table with each data point in a separate column on the SAME row. ✂️ Instead of manually cutting and pasting each data point into a new cell, #PowerQuery can do it for you!
Get the full set at skw-t.com/pqrecipes
Table.Buffer en Power Query fuerza la evaluación completa de una tabla y la guarda en memoria.
Úsalo cuando referencies la misma tabla varias veces en un paso: evita que PQ la recalcule cada vez.
La diferencia puede ser de minutos.
#Excel #PowerQuery #Influexcel
The key idea: Instead of copying worksheets or rebuilding forecasts every week, you:
🟢 Generate your weekly forecast
🟢 Push it through #PowerQuery
🟢 Append it to a history table
🟢 Use that history to analyze how your forecast evolves over time
See what our students are saying! "I liked the in depth demonstrations on how the program is designed to work." T.R. "I loved the recipes developed for every day data problems in business." Elizabeth B. Power Query Academy - Intermediate to Advanced skillwave.training (Skillwave Training logo)
See why students love our flagship #PowerQuery course! 🥰
We'll help you unlock the true power of your data with Power Query in #Excel and #PowerBI! Say goodbye to hours of manual #DataManipulation and hello to quick #DataInsights and informed decisions. Join us today: skw-t.com/pqa
It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using PQ. In this video, I'll give you some alternate methods of interacting with Excel: www.youtube.com/watch?v=bKBe...
#DataAnalysis
A wave of new Dataflow Gen2 capabilities at FabCon Atlanta 2026 by Miguel Llopis #PowerQuery #microsoft #PowerBI blog.fabric.microsoft.com/en-US/blog/a...
It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using PQ. In this video, @excelguru.ca will give you some alternate methods of interacting with Excel: www.youtube.com/watch?v=bKBe...
The Gap Between Basic and Advanced Pivot Tables by Chandeep Chhabra #PowerQuery #Data #PowerPivot #excel #PowerBI www.youtube.com/watch?v=1Iy3...
Less GUIDs: Relative Current Workspace & Items By Name by Ben Gribaudo #PowerQuery #PowerBI bengribaudo.com/blog/2026/03...
Me: Opens #PowerBI, starts working in #PowerQuery.
PBI, shortly thereafter: This preview may be up to 2 days old. Refresh.
Me: 🤨
News From the Data Monkey Brought to you by Excelguru and Skillwave Training (Image of a cyborg monkey in a superhero type crouch) March 24, 2026 In This Issue: • New Video to Show Blank Values in Excel PivotTables • From the AKA Sessions • What's New in Power BI • Latest Meet-up Recording and Next Event Information • Upcoming Courses and Conferences • Available Training Options The finalists for this year's Global Excel Awards have been announced and Ken's super proud to be included in 2 categories: o Ken Puls for Training Provider of the Year o Monkey Tools for Best Excel Add-in It's a real honour to be recognized along with these other great trainers and add-ins. A big thank you to Global Excel Summit for once again running these awards, and to everyone who submitted nominations! Public voting is now open until April 30, 2026 - learn more about all of the categories and finalists, and cast your vote here: https://globalexcelsummit.typeform.com/to/thGGWX91
Our latest newsletter is hitting inboxes right now! 📧
If you'd like to stay up-to-date on what's new in #PowerBI and #Excel, content from our experts, and information on courses, events, and promotions, sign up at skw-t.com/news. We'll also send you our free #PowerQuery eBook. 📘
Classic PQ pain! Try wrapping your column references with Text.Lower() or Text.Upper() in your merge/filter steps. Something like Table.AddColumn(t, "Match", each Text.Lower([Column])). That way you normalize before comparing and casing stops breaking everything. #PowerQuery #Excel
Everyone Sucks at Power BI until They Learn This! by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=wVZ_...
Great starting point! One tip as you go: after cleaning, add a custom column with a "data quality flag" to mark rows that needed fixes. Makes it much easier to audit later and explain your transformations to stakeholders. #PowerQuery #DataAnalytics
Combinas datos de varios ficheros en Power Query y cada uno tiene las columnas con nombres distintos?
No hace falta renombrar a mano. Hay una forma mucho mas limpia de unificarlo todo automaticamente.
https://www.youtube.com/watch?v=3NbIAXOC6EU
#Excel #PowerQuery #Influexcel
At the core of every BI solution is the Data Model. But do you really know how to work with is properly? Dimensional Modeling for the Excel and Power BI Pro Start Learning (Image of a many setting in front of a laptop looking up and to the left thoughtfully with his chin in his hand) (Skillwave Training logo)
Unlock the power of #DimensionalModeling by learning the right way to build solid and scalable Data Models in #Excel and #PowerBI. 💪 This on-demand training brings together #PowerQuery and the #DataModel for powerful #BusinessIntelligence.
➡️Enroll today at skw-t.com/modeling
#DataModeling
Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎The Data Monkey and I will show you how in this latest episode of Monkey Shorts! www.youtube.com/watch?v=PazQ...
#Excel #PowerBI #DataAnalyticsTools
En Power Query, cuando te llegan números como texto, usa Number.From en vez de Cambiar Tipo.
Number.From falla solo en la celda con problema.
Cambiar Tipo puede romper toda la columna.
Pequeño detalle, gran diferencia 💡
#Excel #PowerQuery #Influexcel
Turn your food supply data from a mess into a masterpiece. 🥗📈 Master Power Query automation!
📃 scriptdatainsights.blogspot.com/2026/03/exce...
🎞 youtube.com/shorts/5qjzJ...
🛒 scriptdatainsights.gumroad.com/l/march-skil...
Stop cleaning data manually. Let the machine do it. 🤖👇
#Excel #PowerQuery
Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎 @excelguru.ca and the Data Monkey will show you how in this latest episode of Monkey Shorts! www.youtube.com/watch?v=PazQ...
#Excel #PowerBI #DataAnalyticsTools
That feeling you get when you reduce an Excel file size from 106MB to 65KB by simply using #PowerQuery
...Coz i #PowerQueryAllTheThings 🔥
