How to Create Reports with Power BI Service

Micheál Clesham
By | Updated March 26, 2025 | 15 min read

Key Take Aways

In this article, we’ll take a closer look at how to create a report in Power BI Service, a cloud-based solution. You’ll see how to import data, create and edit reports, and build dashboards with your Power BI reports.

What is Microsoft Power BI?

Power BI is a business intelligence solution from Microsoft that allows users to create dynamic reports and dashboards with little effort. It helps teams uncover actionable, hidden insights in any data source.

If you’re new to Power BI, check out this guide on Getting started with Power BI for a foundational overview.

 

Getting Started with Power BI Reports

This article covers how to build reports, import data, and build dashboards in Power BI service, a cloud-based solution. Although Power BI is aimed at users rather than report designers, it’s a valuable tool for project reporting.

We’ll also take a brief tour of Power BI Desktop, the primary authoring tool for Power BI reports. A full exploration of Power BI Desktop is beyond the scope of this article! As such, you’ll find additional training resources and videos listed at the end of the article if you’d like to learn more.

The examples in this article are based on Microsoft samples and project reports in the BrightWork Power BI Pack.

Project management on Microsoft 365

Watch a demo of BrightWork 365 project and portfolio management templates for Microsoft 365, Power Platform, and Teams.

Key Features of Power BI Reporting

Microsoft Power BI is a ‘’collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.’’

BrightWork Power BI Pack

BrightWork Power BI Pack for SharePoint

 

Before creating your first Power BI report, it’s important to know which services handle import, transformation, and visualizations. Certain services are limited to desktops, as noted below.

 

Power BI Visualizations

Power BI brings data to life with dynamic visualizations. Clear visuals help communicate data-driven stories that inform your business decisions. Built-in options include area charts, bar and column charts, and cards.

You can also find many more amazing visualizations on Microsoft AppSource. Some recently added visualizations include

  • Valq Plan – No-code solution for building complex business plans, scenarios and simulations.
  • Date Picker by Powerviz – Modern calendar view.
  • Drill Down Network PRO – effortlessly visualize categorical data and automatically detects relationships based on category structure.
  • TMap 2.1 – for drilling down chart maps by georegion names.

TMap

TMap 2.1 Donut Chart Symbol Map

 

Power Query – Desktop

Power Query is the engine for importing data and transforming (cleaning) data before loading it into the report area. The ‘Power Query’ editor provides an interface for applying transformations.

Power BI Desktop Query Editor Window

 

Options include:

  • Add or remove rows and columns
  • Separate rows or columns
  • Remove null values
  • Remove rows with blank values.

 

Changes applied in the Power Query editor do not impact the original dataset. Power Query uses connectors as data sources. Some recently updated connectors include:

  • Snowflake
  • Planview OKR
  • BitSight Security Ratings
  • Starburst Enterprise
  • And others

 

You can view a full list of all the connectors and data sources, including SQL databases (Azure SQL, MySQL, etc.), Excel spreadsheets, and cloud services.

 

Power Pivot – Desktop

Power Pivot builds data models, defines relationships between tables, and performs calculations. It uses Data Analysis Expressions (DAX) to analyze data, similar to Excel functions.

Power BI offers over 600 DAX functions, such as sum, average, max, and count. Users can also create custom functions.

 

OneDrive and SharePoint Integration – Desktop

 

Viewing Power BI files directly within OneDrive for Business and SharePoint allows users to streamline collaboration.

A Power BI report on SharePoint makes it easier to share and manage reports within teams. The public view is enabled by default but can be disabled by Power BI admins.

Once you’ve clicked on the Power BI file, it opens immediately in your browser without any need to download it.

 

Power BI Reports – Desktop and Service

A Power BI report consists of multiple visuals and can span multiple pages.

Reports connect to one dataset, or data model, only.  Power BI can combine multiple data sources into a single report.

Power BI Service Sample Report

 

Unlike an Excel spreadsheet, Power BI offers interactive reports with options to filter, slice, and drill down.

Automatic refresh updates all visuals in a report based on a fixed interval, for example, every hour or based on changes in the data.

 

Power BI Dashboards – Service

A Power BI dashboard is a one-page summary of your data with visualizations or tiles.

Power BI Service Sample Dashboard

 

Each tile links to a report, making it easy to drill down for more detail as needed. A dashboard can contain links to multiple reports, providing a quick overview of your data in one place. This feature is only available in the Power BI Service.

Data Model Editing – Service

Since August 2023, Power BI Service has allowed direct data model modifications. This negates the tedious task of opening Power BI Desktop to make changes and republish. It also allows users to collaborate on the same data model simultaneously.

This feature pairs quite nicely with the Model Explorer within the model view. You can see and navigate through all dataset semantic objects in location!

 

Differences Between Power BI Desktop and Power BI Service

At this point, you may be wondering if you should create and edit reports in the Power BI Desktop application or Power BI Service.

Why Use Power BI Desktop?

Power BI Desktop is the best choice for users to create project reports. Using this application is best for:

  • Building project reports with data import, transformation, and modeling.
  • On-page interaction for direct visual formatting.
  • Tracking all activities in one place.

 

Since Power BI Desktop requires practice and knowledge of data modeling, it’s essential to use the Query Editor and Model tool correctly before creating any visualizations.

If you are using a clean dataset and need to create reports and dashboards to share reports with your team, Power BI Service is the right tool. Below is a brief comparison between Power BI Desktop and Service.

Power BI Reports: Desktop vs. Service

  Desktop Service
Cost Free A free license to create reports.
A paid license to share reports.
Data Sources Import data from a wide range of sources. Import data from a wide range of sources.
Data Sources One data set per report One or more reports and data sets per dashboard.
Data Editing Transform (clean) data for usage. Use original data.
Analysis Analyze data using models and DAX functions. Generated by Power BI
Visualizations Build and edit visualizations with on-object interactions. Build and edit visualizations
Dashboards No Create and share
Workspaces  No Yes
Commenting No Yes
Sharing Publish to Power BI Service to share. Can share with internal/external users.

 

How to Create a Report in Power BI Service

This section explains how to create a Power BI report and a dashboard in Power BI Service using Microsoft’s free Supplier Quality Analysis sample.

1. Import Data

The first step in creating Power BI reports is getting your data. There are a number of ways to import data from within your organization, such as file directories and databases.

You can also copy and paste data from an existing dataset. Select a dataset by choosing Samples and import a pre-configured dataset. The data is imported as-is with no editing options.

Power BI Service Get Data All

 

2. Access Your Workspace

The dataset will appear in your workspace in Power BI Service. Click ‘Get Quick Insights’ from the menu to generate a dashboard while you work on the data.

Your workspace is also where you can assign roles and permissions (Viewer, Contributor, Member, and Admin).

Power BI Service Quick Insight Dashboard

3. Open the Report Builder

Next, select ‘Create Report’ to open the report builder. There are three elements in this area:

  • Canvas – This area is blank until visuals are added
  • Visualizations Pane – Use to add and edit charts.
  • Fields Pane – A list of the fields in your dataset based on the columns in your dataset.

 

Power BI Service Report Builder Overview

4. Add Data and Visualizations

To start creating reports in Power BI, you can either select the relevant fields from your data or pick a visualization. The visualization is displayed on the blank canvas.

5. Add a Field

Click a field to add it to the report. Power BI will automatically add the field to the right area in your chart. You can also drag and drop fields into the axis, legend, and values area.

Power BI Services Build Chart

 

Power BI Service Building a Report

6. Change the Chart if Needed

As you add fields, the chart will start to take shape. Change the visualization anytime using the Visualizations pane.

7. Format Your Report

Once you are happy with the data visualization, it’s time to format the chart. Click the ‘format’ icon to adjust the size and colors of the chart, borders, and tooltips.

If you’d like to add a title or details to the report, click the ‘Text box’ option in the top menu.

8. Preview the Report

Use the ‘Reading View’ to check how the report will appear to others.

Power BI Service Preview a Report

9. Final Touches and Saving

Add more visualizations as needed, and remember to save your work. At any time, personalize your display settings using ‘View.’ Change the size of the report and colors for improved readability.

10. Create a Dashboard

Next, create a dashboard by selecting ‘Pin to a live page.’ You can add the report to an existing dashboard or build a new dashboard. Customize the dashboard by adding tiles and different content types.

Power BI Service Create Dashboard

11. Export and Share

When you’ve finished your work, use the ‘File’ menu to:

 

12. Share Your Report

To share your report, click ‘Share,’ complete the form, and share it with your team. Power BI reports and dashboards may be shared with internal and external users.

That’s it – you’ve taken your first step in creating reports in Power BI Services.

Power BI Service Sharing a Report

 

Considerations for Report Sharing

There are a few things to note about report sharing:

  • Recipients can view and interact with the report or dashboard but can’t edit it.
  • Depending on permissions, recipients can share the reports with others.
  • You will need a Power BI Pro license to publish reports. Recipients will also need a license to view the content.

 

For more details on sharing, visit this Microsoft article.

BrightWork 365 and Power BI

BrightWork 365 is built on Power Platform and uses Power BI and Power Automate as follows: 

  • Microsoft Dataverse serves as the data platform and supports business process management, such as stage-gate project lifecycles.
  • Power BI gives senior executives and PMO Leads visibility into portfolios, programs, and projects.
  • Using connectors and content packs, data can be pulled from hundreds of on-premises and cloud sources into a single reporting engine.

 

Workflow Automation with Power Automate

Power Automate drives workflows and automation. Project teams have vast amounts of data. Power BI dashboards allow senior executives to access, analyze, and act on this data.

Discover BrightWork 365 in Action

Experience how BrightWork 365 combines Microsoft 365 with proven project and portfolio management processes.

Watch the BrightWork 365 Video Tour.

Resources and Videos

 

Editor’s Note: This post was originally published in September 2020 and has been updated for freshness, accuracy, and comprehensiveness.

 

Image credit 

Project management on Microsoft 365

Watch a demo of BrightWork 365 project and portfolio management templates for Microsoft 365, Power Platform, and Teams.

Micheál Clesham
Micheál Clesham

Micheál is a SaaS product marketing specialist with BrightWork. For the better part of the decade, our in-house host has created engaging webinars and content with insights from Project Management Gurus and thought leaders. His go-to theme is Project Management best practices including project communication, collaboration and agile ways of working. Outside of work, Micheál likes to find new stories through podcasts, movies, sports, and travel.

Read Full Bio
Don't forget to share this post!