In this article, you can find the best Power BI learning resources to master Power Query, DAX, and Power BI. Whether you’re looking for free content or want to invest in a book, this guide has it all. At the end of the post, you can also find my favorite LinkedIn voices to follow.
Table of contents
For some of the links in this article, I may receive affiliate income. This helps me in supporting my website and comes at no additional cost to you.
Power Query Resources
Power Query is a useful tool that allows you to clean, transform, and shape your data before you start analyzing it in Power BI. So what is the best way to learn Power Query?
In this section, you can find the most valuable Power Query resources out there. We’ll go over some of the top books, blogs, and YouTube channels that have helped me over the years. Whether you’re a beginner or an advanced user, there is something here for you.
The language behind Power Query is called M, short for Power Query M Formula language. Whereas it is increasing in popularity, it is not as popular as DAX, and therefore, there is less content on it.
Power Query: Books
Books are a great way to get a deeper understanding of a topic, and this section has my top 3 books on Power Query. Here they are:
Author | Title |
---|---|
Rick de Groot, Greg Deckler, Melissa de Korte | Definitive Guide to Power Query M |
Gil Raviv | Collect, Combine & Transform Data Using Power Query |
M Escobar, K Puls | Master Your Data with Power Query in Excel & Power BI |
So when should you buy which? I’m one of the authors of the first book: ‘The Definitive Guide to Power Query M. It focuses on learning the M language and will help you tremendously in understanding syntax and tweaking your code. I would say this is for users who have seen some of the user-interface.
The other two books are much more oriented at performing tasks with the user-interface. Whereas they won’t teach you the fundamental M language concepts, they are very good at teaching how to solve problems using the buttons in Power Query.
Power Query: Blogs and YouTube Channels
If you’re not much of a reader, then this section may be for you. Here, we’re gonna take a look at some of the top Power Query bloggers and YouTubers out there. I’ve compiled a list of creators and their blogs and YouTube channels, along with their LinkedIn profiles and links to their websites so you can easily check them out.
And what’s really awesome is that these are available for free. I consider them the best free Power Query M resources currently available.
🔗 LinkedIn profile | 🌐 Blog | ▶️ YouTube Channel
Creator | Blog/Channel | |
---|---|---|
🔗Rick de Groot | BI Gorilla | 🌐▶️ |
🔗Rick de Groot | Powerquery.how | 🌐 |
🔗Chandeep Chabra | Goodly | 🌐▶️ |
🔗Mynda Treacy | My Online Training Hub | 🌐▶️ |
🔗Ken Puls | Excelguru | 🌐▶️ |
🔗Ruth Pozuelo | Curbal | 🌐▶️ |
🔗Jon Acampora | Excel Campus | 🌐▶️ |
🔗Miguel Escobar | The Power User | 🌐▶️ |
🔗Purna Duggirala | Chandoo | 🌐▶️ |
🔗Marc Proctor | Excel Off The Grid | 🌐▶️ |
🔗Leila Gharani | XelPlus | 🌐▶️ |
🔗Oz du Soleil | Excel On Fire | 🌐▶️ |
🔗Kresimir Ledinski | Exceed Learning | 🌐▶️ |
🔗Wyn Hopkins | Access Analytic | 🌐▶️ |
🔗John MacDougall | How To Excel | 🌐▶️ |
🔗Antriksh Sharma | AntMan BI | 🌐▶️ |
🔗James Andrew | Matador Software | ▶️ |
🔗Lars Schreiber | The Self-Service BI Blog | 🌐 |
🔗Imke Feldman | The BIccountant | 🌐 |
🔗Tim Heng, 🔗Liam Bastick | Sum Product | 🌐 |
🔗Ben Gribaudo | Power Query M Primer | 🌐 |
🔗Chris Webb | Crossjoin | 🌐 |
🔗Soheil Bakhshi | BI Insight | 🌐 |
🔗Gilbert Quevauvilliers | Fourmoo | 🌐 |
🔗Gil Raviv | Data Chant | 🌐 |
🔗Erik Svensen | Erik Svensen | 🌐 |
🔗Ed Hansberry | Ehansalytics | 🌐 |
🔗Maxim Zelensky | Excel Inside | 🌐 |
🔗Jiří Beran | Excel Town | 🌐 |
🔗Cameron Wallace | Dingbat Data | 🌐 |
🔗Sumit Bansal | Trump Excel | ▶️ |
🔗Mike Girvin | Excel Is Fun | ▶️ |
🔗Alejandra Horvath | Alejandra Horvath | ▶️ |
🔗Bhavya Gupta | Bhavya Gupta | ▶️ |
🔗Igor Cotruta | QueryPower | 🌐 |
🔗Miss Microsoft | Miss Microsoft | ▶️ |
DAX Resources
Next we move onto resources for learning DAX. DAX stands for Data Analysis Expressions, it’s a formula language that you can use to create calculations at the front-end in Power BI. Many users struggle in the beginning because the language is hard to grasp without theory. So here follow some quality resources to learn DAX.
DAX: Books
Mastering DAX requires experience, but to get started, I recommend reading the theory of different DAX concepts. Below, you can find the best books on DAX that will provide you with structured content to improve your knowledge.
Creator | Title |
---|---|
Marco Russo, Alberto Ferrari | The Definitive Guide to DAX 2nd Edition |
Marco Russo, Alberto Ferrari | DAX Patterns |
Matt Allington | Supercharge Power BI |
Avi Singh, Rob Collie | Power Pivot and Power BI |
Philip Seamark | Beginning DAX with Power BI |
Philip Seamark, Thomas Martens | Pro DAX with Power BI |
Michiel Rozema, Henk Vlootman | Extreme DAX |
DAX: Blogs and YouTube Channels
If you want more than just a book, you may like this section. Below blogs and YouTube channels are the best places to learn DAX for free. Power BI revolves around more than DAX, so naturally, some of these channels may cover other topics too. But more importantly, they have a lot of resources for learning DAX.
🔗 LinkedIn profile | 🌐 Blog | ▶️ YouTube Channel
Creator | Blog/Channel | |
---|---|---|
🔗Rick de Groot | BI Gorilla | 🌐▶️ |
🔗Marco Russo,🔗Alberto Ferrari | SQLBI | 🌐▶️ |
🔗Sam McKay,🔗Brian Julius | Enterprise DNA | 🌐▶️ |
🔗Ruth Pozuelo | Curbal | 🌐▶️ |
🔗Reid Havens | Havens Consulting | 🌐▶️ |
🔗Parvinder Chana | PeryTUS | 🌐▶️ |
🔗Leila Gharani | XelPlus | 🌐▶️ |
🔗Parker Stevens | BI Elite | 🌐▶️ |
🔗Antriksh Sharma | AntMan BI | 🌐▶️ |
🔗Alice Drummond | DiscoverEI | 🌐▶️ |
🔗Wise Owl Tutorials | Wise Owl Tutorials | 🌐▶️ |
🔗Matt Allington | Excelerator BI | 🌐 |
🔗Jeffrey Wang | PBIDAX | 🌐 |
🔗Bernat Agulló Roselló | Esbrina | 🌐 |
🔗Amal Ben Rebai | Amal Ben Rebai | 🌐 |
🔗Mark Walter | Story BI | 🌐 |
🔗Phil Seamark | Dax.tips | 🌐 |
🔗Benoit Fedit | Datakuity | 🌐 |
🔗Daniil Maslyuk | XXL BI | 🌐 |
🔗Atefeh Nakisa | Atefeh BI | 🌐 |
🔗Jihwan Kim | Jihwan Kim | 🌐 |
🔗Chris Barber | Starschema | 🌐 |
⚪Endjin | Endjin | 🌐 |
🔗Bas Dohmen | How to Power BI | ▶️ |
🔗Greg Deckler | MS Hates Greg | ▶️ |
🔗Raja Ayub | The Power BI Guy | ▶️ |
🔗Fernan Espejo | Solutions Abroad | ▶️ |
Power BI Resources
Besides DAX and M, Power BI has a lot of other aspects to work with. You can think of Visualizations, Data Modeling, and External tools. But also how to work with the Power BI Service and the Power BI Admin portal. Here are some of the best resources to learn Power BI.
Power BI: Books
The below table contains some of the best books to learn Power BI. They are my favorites with regard to Power BI topics outside of DAX and M.
Author | Title |
---|---|
Soheil Bakhshi | Expert Data Modeling with Power BI |
Greg Deckler, Brett Powell | Mastering Microsoft Power BI |
Greg Deckler, Brett Powell | Microsoft Power BI Cookbook 2nd Edition |
Greg Deckler | Learn Power BI |
M Russo, A Ferrari | Analyzing Data with Power BI & Power Pivot |
Soheil Bakhshi | Expert Data Modeling with Power BI |
D Knight, M Pearson | Microsoft Power BI Quick Start Guide |
Bhavik Merchant | MS Power BI Performance Best Practice |
Ralph Kimball | The Data Warehouse Toolkit |
Christopher Adamson | Star Schema |
Luca Zavarella | Extending Power BI with Python and R 2nd Edition |
Mary-Jo Diepeveen | Artificial Intelligence with Power BI |
Cole Nussbaumer Knaflic | Storytelling with Data |
Power BI: Blogs and YouTube Channels
It’s astonishing to find there is so much content available to learn Power BI for free, whether you prefer to learn Power BI from the best YouTube Channels or prefer to read articles on Power BI blogs.
I have found below to be the best blogs and YouTube Channels to learn Power BI. They’re particularly helpful in grasping a wide variety of topics.
🔗 LinkedIn profile | 🌐 Blog | ▶️ YouTube Channel
Creator | Blog/Channel | |
---|---|---|
🔗Adam Saxton,🔗Patrick LeBlanc | Guy in a Cube | 🌐▶️ |
🔗Mike Carlo,🔗Seth Bauer | PowerBI.Tips | 🌐▶️ |
🔗Reza Rad, 🔗Leila Etaati | Radacad | 🌐▶️ |
🔗Mara Pereira | Data Pears | 🌐▶️ |
🔗Parvander Chana | PeryTUS | 🌐▶️ |
🔗Nikola Ilic | Data Mozart | 🌐▶️ |
🔗Laura Graham-Brown | Hat Full Of Data | 🌐▶️ |
🔗Carlos Barboza | Spilled Graphics | 🌐▶️ |
🔗Fowmy Abdulmuttalib | Excel Fort | 🌐▶️ |
🔗Johnny Winter | GreySkull Analytics | 🌐▶️ |
🔗Paul Turley | SQL Server BI | 🌐▶️ |
🔗Kerry Kolosko | Kerry Kolosko | 🌐▶️ |
🔗Melissa Coates | Coates Data Strategies | ▶️ |
🔗Alice Drummond | DiscoverEI | 🌐▶️ |
🔗Christopher Wagner | Kratos BI | 🌐▶️ |
🔗Ben Ferry | Power BI Guy | 🌐▶️ |
🔗Oscar Martínez Valero | Bibb | 🌐▶️ |
⚪Pragmatic Works | Pragmatic Works | 🌐▶️ |
🔗Marc Lelijveld | Data Marc | 🌐 |
🔗Sam Fischer | Apex Insights | 🌐 |
🔗Kurt Buhler | Data Goblins | 🌐 |
🔗Meagan Longoria | Data Savvy | 🌐 |
🔗Teo Lachev | Prologica | 🌐 |
🔗Rob Collie | P3Adaptive | 🌐 |
🔗Marcus Wegener | Think BI | 🌐 |
🔗Just Blindbæk | JustB Smart | 🌐 |
🔗Warren Dean | Data Tale | 🌐 |
🔗Martin Rojze | Data Martin | 🌐 |
🔗Sue Bayes | Data Bayes | 🌐 |
🔗Ed Hansberry | Ehansalytics | 🌐 |
⚪WallStreet Mojo | Wallstreet Mojo | 🌐 |
⚪MSSQLTips | MSSQLTips | 🌐 |
🔗Bas Dohmen | How to Power BI | ▶️ |
🔗Alex Freberg | Alex the Analyst | ▶️ |
🔗Ben Howard | Ben Howard | ▶️ |
🔗Avi Singh | Power BI Pro | ▶️ |
🔗Rahim Zulfiqar Ali | Excel Basement | ▶️ |
🔗Mohammed Adnan | Taik18 | ▶️ |
So far, we have seen a lot of different Youtube Channels and blogs. However, some important sources of information that are still missing are the voices that share on LinkedIn.
Linkedin Voices
A lot of really good content appears through LinkedIn. And a lot of the LinkedIn voices don’t have their own blog. Below, you find a selection of people who share valuable content through Linkedin. Make sure to follow them!
Name | Name | Name |
---|---|---|
🔗 Helen Wall | 🔗 Brian Julius | 🔗 Štěpán Rešl |
🔗 Rick de Groot | 🔗 Alex Powers | 🔗 Gerard Duggan |
🔗 Mathias Halkjær Petersen | 🔗 Kathrin Borchert | 🔗 Jocelyn Rivera |
🔗 Excel BI / Vijay A. Verma | 🔗 Owen Price | 🔗 Injae Park |
🔗 Arno Wakfer | 🔗 James Andrew | 🔗 Marcus Wegener |
🔗 Nikola Ilic | 🔗 Kavita Behera | 🔗 Greg Philips |
🔗 Steve Campbell | 🔗 Melissa de Korte | 🔗 Pascal Kiefer |
🔗 Matthias Friedman | 🔗 Gustaw Dudek |
Summary
And that rounds up my best training resources for Power BI. As this article showed, there is an enormous amount of content available, and it can be overwhelming. My advice would be to pick a topic you want to improve on and have a look at which of the authors appeals to you.
You can pick and choose whether you prefer written content online or in book form. Perhaps you prefer videos. And if neither of these fits your needs, you could always look into purchasing a structured paid course. Whatever your preference, I hope this article sent you in the right direction.
Did I miss an important resource? Let me know in the comments so we can keep this page up to date.
Happy learning!
Recommended Reading…
Power Query Foundations
Beginners Guide to Power Query
List Functions (200+ Examples)
Text Functions (150+ Examples)
Creating Tables (40+ Examples)
Generate the Ultimate Date Table
Advanced Topics
Master List.Generate with Easy Examples
Deep Dive into List.Accumulate
Exceptional Compilation.
Also you may want to add ( https://www.linkedin.com/in/aditya-darak/ ) under top voices of DAX and Power BI.
Hi Ric, Thanks for the mention under LinkedIn voices. A great list of resources you have put together. Regards Arno
O Canal “Power BI na Real” pode ser uma excelente fonte de conhecimento sobre o Power BI para a comunidade brasileira, e sua inclusão pode ser valiosa para aqueles que procuram aprender mais sobre essa ferramenta de análise de dados.
THE comprehensive list, Thanks a lot !
Thanks Rick. A very comprehensive list of resources. The challenge as you say, is it can be overwhelming for beginners in terms of resources
That’s very true. Just take a few you like, and get started 🙂 you’ll find some you like and can stick to those. It’s nearly impossible to read all.
🤞Rick
Merci bien !
very resourceful . I think you can add one more you tube channel Chandoo (Chandoo.org) .
beside of that I loved it .
Sumit, thank you for the suggestion, I expanded the list 🙌🏻
It’s a resourceful and complete list
Thanks Rick!