559 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|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.|
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.
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.
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.
25 Aytoun Street