Prompt for a Folder at Refresh
I got a comment on my blog the other day from David, asking if we could make Power Query prompt for a folder at refresh, allowing us to choose which folder to should be used to consolidate files. That sounds
I got a comment on my blog the other day from David, asking if we could make Power Query prompt for a folder at refresh, allowing us to choose which folder to should be used to consolidate files. That sounds
I’m pleased to announce that I’m just opened registration for 3 days of Excelguru live training courses in May 2015. Master Your Excel Data This course will focus on using tables, PivotTables and Power Query to master your Excel data.
Some time ago I posted a technique to pass parameters to Power Query via an Excel table. In a comment on that post, Anand asked “Can I pass the parameter to a SQL Table as well?” The question could mean
I was chatting with my friend Scott of www.tinylizard.com today, discussing the structure of the M language, and how it’s kind of weird compared to VBA, C# and such. Well, “what the #?”, I figure. I’m going to do a
Earlier this week I received an email asking for help with a Power Pivot model. The issue was that the individual had built a model, and wanted to add slicers for value fields. In other words, they’d built the DAX
For the first post of the new year, I thought I’d tackle an interesting problem; how to Transpose Stacked Tables in Power Query. What’s do I mean by Stacked Tables? It’s when your data looks like this: Notice that we’ve
I’m quite proud of the fact that I’ve managed to publish a new blog post every Wednesday since September 2014… among others from earlier in the year, but now it’s time to take a quick break. So this will be
A couple of weeks back, I received a comment on my “Force Power Query to Import as a Text File” blog post. Rudi mentioned that he’d really like to see a method that would let us Treat Consecutive Delimiters as One;
We're back with post two of Miguel's week. This time, he is going to take his previous solution and show us how versatile Power Query can be, leveraging code he's already written and Making Transformations Re-Usable. Have at it, Miguel! Making Transformations Re-Usable In
This post illustrates a cool technique that I learned at the MVP summit last week, allowing us to use Power Query to merge multiple files with properties from the file in the output. A specific example of where this is useful is
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.