Getting to Know Power BI
Power BI is Microsoft’s data visualization solution

Power BI Desktop is composed of four editors:

Power Query

Wirh Power Query Editor, you will extract, transform and load (ETL) your data. The Power Query editor is an add-in of Power BI Desktop which allows users to gather data from different sources such as Excel tables, databases and websites.

The language behind Power Query’s functions is M (I know, very creative). To access Power Query from Power BI Desktop, select Home > Transform Data.



With Data Editor, the user assigns the final formats to the different columns and tables. Also, the user is able to create new tables and columns, using either pane tools or DAX code. Data resembles Excel tables, both in appearance and in functionality.



With Model Editor, the user creates relations among tables. Modeling data is a crucial aspect, not only within Power BI but also within Business Intelligence as a field. Model gives you the ability to link tables using drag-and-drop tools.



Once you have loaded and organized your data, it is time to visualize it. With the Report Editor, the user is able to transform data into insights via a large selection of visualization tools.

In Visualization, the user is able to create measures, design a report’s background and set up filters, among other features.


Most of the posts in this blog series will reference these four editors frequently.

Getting to Know Power BI
Older post

Getting to Know the Services in Power BI

A brief description of the three main services offered by Power BI

Newer post

Create Calendar Tables in Power BI

Tips on creating basic calendar tables.

Getting to Know Power BI