Native Database Query Security Prompts
In a comment on my Parameter Tables post, Talha asks why we get prompted with a Native Database Query message each time the value of the parameter used in a SQL query changes: I had a question. The value I
In a comment on my Parameter Tables post, Talha asks why we get prompted with a Native Database Query message each time the value of the parameter used in a SQL query changes: I had a question. The value I
This was a great question that came up in my M is for (Data) Monkey session at the Amsterdam Excel summit: Can we use dynamic ranges in Power Query? If I recall correctly, this was asked by Gašper Kamenšek, after
I was presented with an interesting problem last week: how to create running totals in Power Query. There doesn’t appear to be a built in method to do this, so I thought it would make an interesting use case study.
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 sent this today from a friend. He was a bit frustrated, as he got a message from Power Query that read “Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps and so may not directly access a
I’ve posted on consolidating worksheets before, but in a task I got asked to do last week, I took a slightly different approach. This approach allows consolidating worksheet print areas to grab the data that I need. Background In the previous post,
I got a comment on a previous post today, which made me realize I’d promised this but never posted it. So let’s look at how to combine multiple workbooks together in Power Query, providing they have the same format. Yes,
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
Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the columns of which is a date. But when you complete
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
