Written By Rick de Groot

Rick is the founder of BI Gorilla. He believes learning is one of life's greatest pleasures and shares his knowledge to help you improve your skills.

Best Resources to Learn Power BI

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:

AuthorTitle
Rick de Groot, Greg Deckler, Melissa de KorteDefinitive Guide to Power Query M
Gil RavivCollect, Combine & Transform Data Using Power Query
M Escobar, K PulsMaster 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

CreatorBlog/Channel
🔗Rick de GrootBI Gorilla🌐▶️
🔗Rick de GrootPowerquery.how🌐
🔗Chandeep ChabraGoodly🌐▶️
🔗Mynda TreacyMy Online Training Hub🌐▶️
🔗Ken PulsExcelguru🌐▶️
🔗Ruth PozueloCurbal🌐▶️
🔗Jon AcamporaExcel Campus🌐▶️
🔗Miguel EscobarThe Power User🌐▶️
🔗Purna DuggiralaChandoo🌐▶️
🔗Marc ProctorExcel Off The Grid🌐▶️
🔗Leila GharaniXelPlus🌐▶️
🔗Oz du SoleilExcel On Fire🌐▶️
🔗Kresimir LedinskiExceed Learning🌐▶️
🔗Wyn HopkinsAccess Analytic🌐▶️
🔗John MacDougallHow To Excel🌐▶️
🔗Antriksh SharmaAntMan BI🌐▶️
🔗James AndrewMatador Software▶️
🔗Lars SchreiberThe Self-Service BI Blog🌐
🔗Imke FeldmanThe BIccountant🌐
🔗Tim Heng, 🔗Liam BastickSum Product🌐
🔗Ben GribaudoPower Query M Primer🌐
🔗Chris WebbCrossjoin🌐
🔗Soheil BakhshiBI Insight🌐
🔗Gilbert QuevauvilliersFourmoo🌐
🔗Gil RavivData Chant🌐
🔗Erik SvensenErik Svensen🌐
🔗Ed HansberryEhansalytics🌐
🔗Maxim ZelenskyExcel Inside🌐
🔗Jiří BeranExcel Town🌐
🔗Cameron WallaceDingbat Data🌐
🔗Sumit BansalTrump Excel▶️
🔗Mike GirvinExcel Is Fun▶️
🔗Alejandra HorvathAlejandra Horvath▶️
🔗Bhavya GuptaBhavya Gupta▶️
🔗Igor CotrutaQueryPower🌐
🔗Miss MicrosoftMiss 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.

CreatorTitle
Marco Russo, Alberto FerrariThe Definitive Guide to DAX 2nd Edition
Marco Russo, Alberto FerrariDAX Patterns
Matt AllingtonSupercharge Power BI
Avi Singh, Rob ColliePower Pivot and Power BI
Philip SeamarkBeginning DAX with Power BI
Philip Seamark, Thomas MartensPro DAX with Power BI
Michiel Rozema, Henk VlootmanExtreme 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

CreatorBlog/Channel
🔗Rick de GrootBI Gorilla🌐▶️
🔗Marco Russo,🔗Alberto FerrariSQLBI🌐▶️
🔗Sam McKay,🔗Brian JuliusEnterprise DNA🌐▶️
🔗Ruth PozueloCurbal🌐▶️
🔗Reid HavensHavens Consulting🌐▶️
🔗Parvinder ChanaPeryTUS🌐▶️
🔗Leila GharaniXelPlus🌐▶️
🔗Parker StevensBI Elite🌐▶️
🔗Antriksh SharmaAntMan BI🌐▶️
🔗Alice DrummondDiscoverEI🌐▶️
🔗Wise Owl TutorialsWise Owl Tutorials🌐▶️
🔗Matt AllingtonExcelerator BI🌐
🔗Jeffrey WangPBIDAX🌐
🔗Bernat Agulló RosellóEsbrina🌐
🔗Amal Ben RebaiAmal Ben Rebai🌐
🔗Mark WalterStory BI🌐
🔗Phil SeamarkDax.tips🌐
🔗Benoit FeditDatakuity🌐
🔗Daniil MaslyukXXL BI🌐
🔗Atefeh NakisaAtefeh BI🌐
🔗Jihwan KimJihwan Kim🌐
🔗Chris BarberStarschema🌐
⚪EndjinEndjin🌐
🔗Bas DohmenHow to Power BI▶️
🔗Greg DecklerMS Hates Greg▶️
🔗Raja AyubThe Power BI Guy▶️
🔗Fernan EspejoSolutions 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.

AuthorTitle
Soheil BakhshiExpert Data Modeling with Power BI
Greg Deckler, Brett PowellMastering Microsoft Power BI
Greg Deckler, Brett PowellMicrosoft Power BI Cookbook 2nd Edition
Greg DecklerLearn Power BI
M Russo, A FerrariAnalyzing Data with Power BI & Power Pivot
Soheil BakhshiExpert Data Modeling with Power BI
D Knight, M PearsonMicrosoft Power BI Quick Start Guide
Bhavik MerchantMS Power BI Performance Best Practice
Ralph KimballThe Data Warehouse Toolkit
Christopher AdamsonStar Schema
Luca ZavarellaExtending Power BI with Python and R 2nd Edition
Mary-Jo DiepeveenArtificial Intelligence with Power BI
Cole Nussbaumer KnaflicStorytelling 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

CreatorBlog/Channel
🔗Adam Saxton,🔗Patrick LeBlancGuy in a Cube🌐▶️
🔗Mike Carlo,🔗Seth BauerPowerBI.Tips🌐▶️
🔗Reza Rad, 🔗Leila EtaatiRadacad🌐▶️
🔗Mara PereiraData Pears🌐▶️
🔗Parvander ChanaPeryTUS🌐▶️
🔗Nikola IlicData Mozart🌐▶️
🔗Laura Graham-BrownHat Full Of Data🌐▶️
🔗Carlos BarbozaSpilled Graphics🌐▶️
🔗Fowmy AbdulmuttalibExcel Fort🌐▶️
🔗Johnny WinterGreySkull Analytics🌐▶️
🔗Paul TurleySQL Server BI🌐▶️
🔗Kerry Kolosko Kerry Kolosko 🌐▶️
🔗Melissa CoatesCoates Data Strategies▶️
🔗Alice DrummondDiscoverEI🌐▶️
🔗Christopher WagnerKratos BI🌐▶️
🔗Ben FerryPower BI Guy🌐▶️
🔗Oscar Martínez ValeroBibb🌐▶️
⚪Pragmatic WorksPragmatic Works🌐▶️
🔗Marc LelijveldData Marc🌐
🔗Sam FischerApex Insights🌐
🔗Kurt BuhlerData Goblins🌐
🔗Meagan LongoriaData Savvy🌐
🔗Teo LachevPrologica🌐
🔗Rob CollieP3Adaptive🌐
🔗Marcus WegenerThink BI🌐
🔗Just BlindbækJustB Smart🌐
🔗Warren DeanData Tale🌐
🔗Martin RojzeData Martin🌐
🔗Sue BayesData Bayes🌐
🔗Ed HansberryEhansalytics🌐
⚪WallStreet MojoWallstreet Mojo🌐
⚪MSSQLTipsMSSQLTips🌐
🔗Bas DohmenHow to Power BI▶️
🔗Alex FrebergAlex the Analyst▶️
🔗Ben HowardBen Howard▶️
🔗Avi SinghPower BI Pro▶️
🔗Rahim Zulfiqar AliExcel Basement▶️
🔗Mohammed AdnanTaik18▶️

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!

NameNameName
🔗 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!

Share this post:
  1. 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.

    Reply
  2. Thanks Rick. A very comprehensive list of resources. The challenge as you say, is it can be overwhelming for beginners in terms of resources

    Reply
    • 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

      Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.