NEW JOINS in Power Query! | Power BI update April 2024 (LeftSemi and Right Semi)

Let me show you the new joins that were made available on Power BI Desktop April Update 2024
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@andrewwalker5974]

I just played around with this a little but it looks useful. LeftSemi will return fewer rows than an Inner Join if the second table has duplicates. If A has three rows of "Apple", "Banana" & "Orange" and B is "Apple", "Orange", "Orange" the LeftSemi will return only two rows of "Apple" & "Orange" plus the column of nulls. Useful if we want to reduce a table of orders down to those with item lines in a second table where that second table may have duplicate OrderID.

[@CurbalEN]

Great! Didnt think about duplicates! :)

[@evnpresson7258]

I recently discovered their usage within Azure Data Explorer and Kusto and indeed removing duplicates are my main use case.

[@barttitulaerexcelbart9400]

Mmm, I do' not see the advantage yet, if you do not work with large datasets. In PQ you "only" see the first 1000 rows, and an advantage of the regular joins is that you can have a look if the join was done correct. If you want to clear the dataset with double records you can also to this first. But thanks for the video Ruth: you are a frontrunner!!

[@abhijeetghosh27]

hmmm .. new joins.. nice .. now next task is to look for use cases ... 🤔🤔🤔
As always .. easy explanation @Ruth .. good one 😀😀👍

[@mathew9665]

Nice one - thank you

[@nikakalichava8012]

Dope!

[@Arowsky]

Where can I get that joins sheet?

[@williamarthur4801]

Ooh, looks useful, must admit, I don't know about others but I've always found the syntax for joins hard to remember.

[@CurbalEN]

I have the mouse matt as a cheat sheet! Never fails me ;)

[@mattmatt245]

What about non-equi join ? When will this be available in PQ ?

[@CurbalEN]

I dont know :(

[@pachecarla]

Will they be available in dataflows?

[@CurbalEN]

They didnt say! Lets hope ! :)

[@somyasaurabh6735]

Well what is the problem is the tell me what is the matter is the 😂