I’m Posting On The Power Query Blog Too!
source link: https://blog.crossjoin.co.uk/2022/05/16/im-posting-on-the-power-query-blog-too/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
I’m Posting On The Power Query Blog Too!
In the future you’re going see me writing blog posts on the official Power Query blog as well as here on my own personal blog, and indeed the first of these posts went live a few hours ago. It’s on a new M function called Table.StopFolding which, as the name suggests, stops query folding taking place:
https://powerquery.microsoft.com/en-us/blog/stop-query-folding-with-table-stopfolding/
I’m doing this a) because I was asked very nicely by the Power Query team if I could help out, and b) because it doesn’t make sense for announcements about new Power BI or Power Query functionality, however obscure, to be made on my own personal blog rather than on an official product blog. This isn’t going to affect the number of posts here though.
Like this:
Post navigation
6 responses
-
Nathan Watkins says:
Hello, Chris. I was hoping to see you use the StopFolding function after the filter, so that we could see the query stop folding after the filter; I suspect that only an actual maniac would stop folding before an easily foldable filter, but that’s just a suspicion. But will it still work as the next step after using some functions that do fold?
Loading...-
Chris Webb says:
As far as I know it should always stop folding.
Loading...
-
-
Dr Greg Low says:
Hey Chris, how will that affect the Google juice for your posts? I’m sure yours will be fine, but they usually ping content that appears the same on multiple sites.
Loading...-
The content won’t appear on multiple sites though – I’m just going to write the occasional post on the Power Query blog, and those posts won’t appear here.
Loading...-
Ah got it, separate posts on each site. Thanks.
Loading...
-
-
-
KEVIN says:
Hi, my question does not apply to this article, but did not know how to contact you otherwise.
Looking for a solution to create a daily snapshot of event data from Azure to display in Power BI. The event data changes frequently (events opened today might be resolved tomorrow). Want to keep a history of every days snapshot for a month. Hope someone can guide me to a solution. Thanks.Loading...
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Recommend
-
38
Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the
-
7
A Function To Visualise Parallelism In Power Query Diagnostics Data Most of the time I’ve spent looking at Power Query Query Diagnostics data, I’ve been l...
-
38
The M Behind The New Power Query Data Types In Excel The big news this week – at least for me – was the release of the new Power Query data types to the Excel insiders channel. You can read all about it here:
-
18
Optimising The Performance Of Power Query Merges In Power BI, Part 5: Cross Joins In a late addition to the series of posts that I started
-
4
Posting regularly on blog: WordPress or hugo does the tooling matters? I have been running this blog since 2007 19 July 2007 to be precise, during this long timefram...
-
8
You are here: Home / Marketing / Blog Branding: How Niche is Too Niche for a New Blog?Blog Branding: How Niche is Too Niche for a New B...
-
7
One common and plausible argument against nuclear power is that it is too slow. The evidence offered is recent interminable builds in the US and Europe, Table 1. But is this inherent in the technology?
-
6
Monday, 10 July 2023 MySQL error - Packet for query is too large (4,739,923 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable'
-
4
We made it! I tasked myself with writing 30 posts in 30 days for National Blog Posting Month, and somehow I just about managed it (well, including this post — yes, I cheated!). So, what have I learned? Let yourself off the hook Par...
-
3
ParsaF's blog I reached top 100 con...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK