Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI Workflow


Share

The Five Steps

Most Power BI projects follow the same five steps, from raw data to a shared report:

  1. Get dataConnect to Excel, CSV files, databases and more
  2. TransformClean and shape the data in Power Query Editor
  3. ModelRelate tables and write DAX measures
  4. VisualizeBuild report pages with charts and slicers
  5. Publish and sharePut the report in the Power BI service

Steps 1 to 4 happen in Power BI Desktop.

Step 5 happens in the Power BI service.


1. Get Data

Every report starts with data.

On the Home tab, select Get data to connect to a source: an Excel workbook, a CSV file, a database, a web page, or one of the many other sources Power BI supports.

A report can combine several sources.

You will do this step in the First Report chapter, and learn more sources in the Get Data chapter.


2. Transform

Real data is rarely ready to use.

In the Power Query Editor you remove columns you do not need, fix data types, filter out bad rows and rename things.

Power Query remembers every change as a step, so it can repeat all of them each time the data is refreshed.

The Power Query chapter covers this step.

The Power Query Editor window with the Poke Mart Sales query open, showing the data preview and the list of applied steps


3. Model

A data model describes how your tables fit together and what you want to calculate.

In Model view you create relationships between tables, for example between a Sales table and a Products table.

You also write measures with DAX (Data Analysis Expressions), the formula language of Power BI.

The Modeling and DAX chapters cover this step.

A simple DAX measure looks like this:

Total Sales = SUM(Sales[Amount])


4. Visualize

In Report view you turn the model into report pages.

You add visuals such as cards, column charts, line charts and tables, and slicers that let readers filter the page.

All visuals on a page are connected: a click in one visual filters the others.

You build your first report in the next chapter.


5. Publish and Share

When the report is ready, select Publish on the Home tab.

Power BI asks you to save your changes first.

Then sign in with a work or school account, and select a destination workspace, for example My workspace.

Power BI uploads the report and its semantic model to the Power BI service.

There you can share the report, pin visuals to a dashboard, and schedule the data to refresh.

Sharing with others needs a paid license, as explained in Get Started.

The Power BI service is part of Microsoft Fabric, so you may see the Fabric name there too.

A later chapter will cover this step in detail.

The steps are not always done once, in order.

You will often go back: add a new column in Power Query, then a new measure, then a new chart.


Power BI Glossary

These words appear all through Power BI and this tutorial:

TermMeaning
ReportA file of one or more pages with interactive visuals. You build reports in Power BI Desktop and save them as .pbix files.
PageOne screen of a report. Each page has its own tab at the bottom of the canvas.
VisualOne chart, table, card, map or slicer on a page. Also called a visualization.
Semantic modelThe data behind a report, with its tables, relationships and measures. It was called a dataset in older versions of Power BI.
DashboardA single page of tiles in the Power BI service. Each tile is a visual pinned from a report. Dashboards cannot be made in Power BI Desktop.
WorkspaceA place in the Power BI service where reports, semantic models and dashboards are stored and shared. Everyone has a personal My workspace.



Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.