Joins with Power BI and R

Joins will always be around…let’s make them easy

Peter Hui
Towards Data Science
4 min readSep 2, 2020

--

Photo by Mel Poole on Unsplash

I’ve described the basics of joins in my first article. Hope you have found it helpful. In this article, I will show you how these joins can be done using Power BI’s Power Query and also in R using dplyr.

Power BI has a “Click” type ( Using the mouse alot) UI while R has a “Typing” interface (Using the keyboard…

--

--

I write about Power BI, Power Automate and other cool Microsoft power tools. Microsoft certified data analyst. Constant learner and an aspiring writer. 👍