The best Microsoft Power BI books

1 authors have picked their favorite books about Microsoft Power BI and why they recommend each book.

Soon, you will be able to filter by genre, age group, and more. Sign up here to follow our story as we build a better way to explore books.

Shepherd is reader supported. When you buy through links on our website, we may earn an affiliate commission (learn more).

Supercharge Power BI

By Matt Allington,

Book cover of Supercharge Power BI: Power BI is Better When You Learn To Write DAX

Have you ever built a pivot table in Excel? They are great at summarizing data. But they are lousy at answering certain questions. When your manager asks for anything slightly complicated, the Pivot Table Calculated Field is destined to fail. 

The Microsoft team who built the Power Pivot calculation engine realized that Calculated Fields were the weak point of pivot tables. They created an amazing new formula language that could let you answer the hard questions like how are we doing on same-store sales through the first two weekends of December?

The formula language – Data Analysis Expressions – or DAX is powerful but confusing. Matt Allington, another former data analyst has figured out how to use DAX to come up with all of those industry-standard calculations that he used to need as a manager at Coca-Cola. 

He walks you up the DAX learning curve in this book.


Who am I?

I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.


I wrote...

Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

By Bill Jelen,

Book cover of Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What is my book about?

657 Excel mysteries solved. Direct from MrExcel himself, Bill Jelen. If you use Excel 10, 20, 40 hours per week, you will save 50 hours per year with the tricks in this book.

Cleaning Excel Data With Power Query Straight to the Point

By Oz du Soleil,

Book cover of Cleaning Excel Data With Power Query Straight to the Point

If you just want to find out if Power Query is for you, this short book, written by the entertaining host of the Excel On Fire YouTube channel will show you what is possible using Power Query. Oz will show you the types of everyday problems that can be solved using the Get & Transform section of the Data tab in Excel. Once you get a taste of what is possible, you will be ready to dive in with Ken Puls’ book.


Who am I?

I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.


I wrote...

Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

By Bill Jelen,

Book cover of Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What is my book about?

657 Excel mysteries solved. Direct from MrExcel himself, Bill Jelen. If you use Excel 10, 20, 40 hours per week, you will save 50 hours per year with the tricks in this book.

The Absolute Guide to Dashboarding and Reporting with Power Bi

By Kasper De Jonge,

Book cover of The Absolute Guide to Dashboarding and Reporting with Power Bi: How to Design and Create a Financial Dashboard with Power Bi - End to End

Kasper DeJonge works at Microsoft on the Power Query team. Before joining Microsoft, he was a data analyst, just like you. In this book, Kasper walks a data analyst through the steps of modelling your Excel data and getting it published on a Power BI dashboard. Along the way, his examples are designed to get you up to speed with the important aspects of Power BI.


Who am I?

I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.


I wrote...

Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

By Bill Jelen,

Book cover of Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What is my book about?

657 Excel mysteries solved. Direct from MrExcel himself, Bill Jelen. If you use Excel 10, 20, 40 hours per week, you will save 50 hours per year with the tricks in this book.

Master Your Data with Power Query in Excel and Power BI

By Ken Puls, Miguel Escobar,

Book cover of Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

Microsoft quietly slipped the Get & Transform tools onto the Data tab in Excel in 2016. These tools are incredibly powerful – you clean your data once and Excel will remember how to clean your data every month, every week, every day, every hour. Ken Puls and Miguel Escobar will show you all of the best tricks for using these tools.


Who am I?

I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.


I wrote...

Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

By Bill Jelen,

Book cover of Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What is my book about?

657 Excel mysteries solved. Direct from MrExcel himself, Bill Jelen. If you use Excel 10, 20, 40 hours per week, you will save 50 hours per year with the tricks in this book.

Power Pivot and Power BI

By Rob Collie, Avichal Singh,

Book cover of Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

Rob Collie was a pioneer at Microsoft. After leaving the Excel team, he helped architect the tools that would become Power Pivot and Power BI. He left Microsoft and started his own consultancy, helping big companies answer important questions in just a few hours with Power Pivot.

His books are the best-selling books in the category. 

While Matt Allington will get you up to speed, Rob will explain every nuance of Power Pivot, DAX, and Power BI.


Who am I?

I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.


I wrote...

Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

By Bill Jelen,

Book cover of Power Excel 2019 with MrExcel: Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

What is my book about?

657 Excel mysteries solved. Direct from MrExcel himself, Bill Jelen. If you use Excel 10, 20, 40 hours per week, you will save 50 hours per year with the tricks in this book.

New book lists related to Microsoft Power BI

All book lists related to Microsoft Power BI

Bookshelves related to Microsoft Power BI