Call Us: +32 2 466 00 16
Email: info@u2u.be
Follow Us:

Creating Power BI Paginated Reports

2 days
UPBIPR
2 days

Upcoming Sessions

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Book now

Interested in a private company training? Request it here.

Introduction to Power BI Paginated Reports

In this module you will get a birds eye view of the capabilities of Power BI Paginated Reports.

  • Overview of Power BI reporting options
  • Limitations of regular Power BI Reports
  • Building Paginated Reports in the browser
  • LAB: Building a basic Power BI Paginated Report

Working with Power BI Report Builder

The browser based editor for paginated reports is very basic. Luckily there is a way more powerful tool: The Power BI Report Builder. In this module you learn how to install and use this tool.

  • Installing the Power BI Report Builder
  • Exploring the Report Builder features
  • Editing an existing Paginated Report
  • Inspecting the .rdl file format
  • LAB: Edit a Paginated Report

Bring data in your reports

Paginated reports can use the semantic models that regular Power BI reports use as well. But they also support embedded data sets, which are specific to a particular paginated report. In this module you learn to setup these datasets, and learn to build parameterized reports.

  • Connecting to semantic models
  • Using Power Query to setup embedded data sets
  • Using parameters and filters
  • Using parameter lists
  • LAB: Fetching data and build a filtered report

Tablix: Using table, matrix and list visuals

If the report needs to show detailed numbers, a table and matrix (pivot table) are very useful visualizations. In Power BI Paginated Reports, advanced visuals can be build, with different levels of grouping. Also the expressions used in each cell to decide which data to show is discussed in detail.

  • Referencing Fields in Textbox
  • Working with built-in Fields
  • Table and Matrix visuals
  • Working with Groupings
  • Repeating visuals in a List
  • TABLe, LIst and matrIX combined: Tablix
  • LAB: Building a table and matrix visual

Advanced Report Components

Often users want to interact with a report, e.g. drill down in more detailed data, link one report to another, sort data interactively or create a table of content. All these kinds of features are discussed in this module on report enhancements.

  • Interactive navigation (drill through)
  • Displaying data with collapsible regions
  • Multi-select parameters
  • Interactive column sorting
  • Floating headers
  • LAB: Complex Report Components

Adding Charts to your reports

Our brain is still wired to recognize trends in data more rapidly from a graphical representation than from an endless list of numbers. That's why charts, maps and other data visualizations are so popular. In this module you will learn all about these charts, and how to even combine text and charts in a single table or matrix!

  • Advanced charting and Sparklines
  • Plotting data on maps
  • Visualizing KPIs with indicators
  • LAB: Charting Components

Deployment and Migration

Once the report has been tested, it can be either saved locally, or be deployed to the Power BI Service. This module also covers the scenario where your company was building SQL Server Reporting Services in the past, and wants to migrate these to Power BI Paginated Reports.

  • Publish a paginated report to the Power BI Service
  • Uploading .rdl files in a Power BI Workspace
  • Migrating from SQL Server Reporting Services to Power BI
  • LAB: Deploy a Paginated Report

Power BI Paginated Reports are an alternative way to build reports. Although they are less interactive than regular Power BI reports, they are more convenient to build reports that need to be printed, or exported to a wide variety of formats. In this course you will learn how to create new paginated reports with the Power BI Report Builder tool, using both semantic models as well as embedded data sources. Also the deployment of reports to the Power BI services is covered, as well as migration from SQL Server Reporting Services (SSRS) to Power BI Paginated Reports.

This course is intended for people who need to create paginated reports in Power BI. Students should be familiar with the Power BI Service (portal, workspaces, semantic models).

Contact Us
  • Address:
    U2U nv/sa
    Z.1. Researchpark 110
    1731 Zellik (Brussels)
    BELGIUM
  • Phone: +32 2 466 00 16
  • Email: info@u2u.be
  • Monday - Friday: 9:00 - 17:00
    Saturday - Sunday: Closed
Say Hi
© 2024 U2U All rights reserved.