You're reading from Learn Power BI A comprehensive, step-by-step guide for beginners to learn real-world business intelligence

Product type Paperback

Published in Feb 2022

Publisher Packt

ISBN-13 9781801811958

Length 458 pages

Edition 2nd Edition

Languages

DAX

Tools

Power BI

Concepts

Business Intelligence

Author (1):

Greg Deckler

View More author details

Table of Contents (19) Chapters

Preface

1. Section 1:The Basics

2. Chapter 1: Understanding Business Intelligence and Power BI FREE CHAPTER

3. Chapter 2: Planning Projects with Power BI

4. Section 2:The Desktop

5. Chapter 3: Up and Running with Power BI Desktop

6. Chapter 4: Connecting to and Transforming Data

7. Chapter 5: Creating Data Models and Calculations

8. Chapter 6: Unlocking Insights

9. Chapter 7: Creating the Final Report

10. Section 3:The Service

11. Chapter 8: Publishing and Sharing

12. Chapter 9: Using Reports in the Power BI Service

13. Chapter 10: Understanding Dashboards, Apps, Goals, and Security

14. Chapter 11: Refreshing Content

15. Section 4:The Future

16. Chapter 12: Deploying, Governing, and Adopting Power BI

17. Chapter 13: Putting Your Knowledge to Use

18. Other Books You May Enjoy

Transforming data

While Power BI did a good job of automatically identifying and categorizing our data, the data is not entirely in the format required for analysis. Therefore, we need to modify how the data gets loaded into the model. In other words, we need to transform the data. To do that, we will cover using a powerful sub-application known as Power Query Editor.

Touring the Power Query Editor

Similar to how we provided a tour of Power BI Desktop in Chapter 3, Up and Running with Power BI Desktop, this section provides a tour of Power Query Editor. Power Query Editor can be launched from the Home tab by choosing Transform data in the Queries section of the Ribbon. Once launched, the following screen will be displayed:

Figure 4.6 – Power Query Editor

As you might expect, the Power Query Editor interface is similar to, and shares common elements with, Power BI Desktop. The Power Query Editor user interface is comprised of eight main areas. Refer...