
Are you ready to level up your Power BI skills? But don’t know where to start looking for the best resources? This post has got you covered. Below, you will find the ultimate guide to the top Power BI books, blogs, YouTube channels, and LinkedIn influencers.
In this article, you’ll find the best Power BI learning resources to master Power Query, DAX, and Power BI as a whole. I’ve done the legwork and handpicked the best resources out there, so you don’t have to waste time searching.
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 favourite LinkedIn voices to follow. So, buckle your seatbelts and get ready for the ride because this guide is going to be your go-to for mastering Power BI.
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
Alright, so you’re ready to dive into the world of Power Query? That’s great! Power Query is like a magic tool that allows you to clean, transform, and shape your data before you start analyzing it in Power BI.
In this section, we’re going to take a look at the best Power Query resources out there. We’ll go over some of the top books, blogs, and YouTube channels that can help you master Power Query. Whether you’re a beginner or an advanced user, these resources will give you the tips and tricks you need to work with your data like a pro.
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 in this section, we’re gonna take a look at the top 5 books on Power Query.
Now, you might be thinking that Power Query is a relatively new tool and there are not many books available, but don’t worry. These 5 books are packed with valuable information and tips that will help you master Power Query. From beginner to advanced techniques, these books cover it all.
So, get ready to take a good look at the best Power Query books available on the market!
Author | Title |
---|---|
Gil Raviv | Collect, Combine & Transform Data Using Power Query |
M Escobar, K Puls | Master Your Data with Power Query in Excel & Power BI |
Andrea Janicijevic | Power Query Cookbook |
Adam Aspin | Data Mashup with Microsoft Excel Using Power Query |
M Escobar, K Puls | M is for Data Monkey (release 2015) |
Do note that the last book originates from 2015 and may be somewhat outdated. However, it still contains timeless and valuable examples of how to use M.
Power Query: Blogs and YouTube Channels
One of the best ways to learn is by following experts in the field. In this section, 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. These creators are experts in the field, and they share their knowledge, tips, and tricks in a way that’s easy to understand and follow.
So, whether you’re looking for beginner or advanced techniques, these blogs and YouTube channels have it all. And what’s really awesome is that these are available for free. They are the best free Power Query M resources currently available.
So, get ready for some learning and let’s dive into the best Power Query blogs and YouTube channels out there!
🔗 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 | 🌐▶️ |
🔗Sam McKay, 🔗Brian Julius | Enterprise DNA | 🌐▶️ |
🔗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 | ▶️ |
⚪Miss Microsoft | Miss Microsoft | ▶️ |
DAX Resources
So you’re ready to take your DAX skills to the next level? Fantastic. DAX stands for Data Analysis Expressions, it’s a formula language that you can use to create calculations and queries in Power BI.
DAX is a powerful language that allows you to create complex calculations and analyze your data in ways you may have only dreamt of before. The language may not feel intuitive at first.
Many users struggle in the beginning because the language is hard to grasp without theory. For that reason, you may find yourself looking for quality resources to learn DAX online. Well, this section has got you covered!
DAX: Books
Mastering DAX requires experience, but to get started, I recommend reading the theory of different concepts in DAX. Below, you can find the best books on DAX that will provide you with structured content to take you from beginner to advanced DAX programmer.
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
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 | 🌐 |
🔗Annie Shahid | Scient Solutions | 🌐 |
⚪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.
Give yourself a head start and learn power bi from scratch with the quality content shared below.
Power BI: Books
The following table contains some of the best books to learn Power BI. They are my favourites 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 |
Adam Aspin | Pro Power BI Desktop |
Ralph Kimball | The Data Warehouse Toolkit |
Christopher Adamson | Star Schema |
Luca Zavarella | Extending Power BI with Python and R |
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
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!