Changes coming to Power Query

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Power Query changes - conditional splits and SharePoint selectors
A look at some of the features coming soon to Power Query (as always with Power Query, you should pay attention to the online version, which seems to get all changes first), such as a conditional split transform and easier selection of SharePoint sites.

Posted by Andy Brown on 29 September 2023

In this blog

Selectable SharePoint folders
A conditional split transform

If you want to know what changes are coming to Power Query, have a look at this Microsoft blog:

The release wave 1 plan for Power Query (don't bother clicking on the link to the release wave 2 plan that this contains - it's very vague!).

Two features caught our eye: a new conditional split transform, and the ability to select SharePoint sites (rather than having to type them in). Since Microsoft are borrowing features from other applications, I've shown below what I think each will look like using these original applications to illustrate the changes as I expect them to look.

Selectable SharePoint folders

In Power Automate you can choose your SharePoint folders, libraries and dcocuments from drop lists:

Choosing a SharePoint site ...

It seems that this feature is coming to Power Query (online, at any rate) soon.

A conditional split transform

SQL Server Integration Services (SSIS) - one of my favourite software applications - has been doing this for many years:

This conditional split transform is separating films according to whether they are U certificate or not

This transform is coming soon to Power Query, it appears - when used in a series of transformation steps it will generate two or more separate queries.

You've been able to create flow diagrams like this for some time now (I blogged about it back in 2021), although you do need to be logged on to Power BI Service with a Power BI Pro or Premium account to do this.

Some other pages relevant to the above blog include:

This blog has 0 threads

Add a new post