Creating Power BI Paginated Reports
UPBIPR
2 days
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
- Working with the Report Builder Wizards
- Editing an existing Paginated Report
- Inspecting the .rdl File Format
- Creating a basic Table Report
- Referencing Fields in Textbox
- Working with built-in Fields
- Aggregations and Calculations
- Working with Groupings
- Formatting Pages
- LAB: Create a Paginated Report with Report Builder
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
- Multi-select Parameters
- Lookup Functions
- LAB: Fetching Data and build a filtered Report
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
- Interactive Column sorting
- Creating a Table of Contents with Document Maps
- TextBoxes and Placeholders
- Recursive Parents
- TABLe, LIst and matrIX combined: Tablix
- Repeating Visuals in a List
- Using Subreports
- 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!
- Using Charts
- Advanced Charting and Sparklines
- Plotting Data on Maps
- Visualizing KPIs with indicators and Gauges
- Specifying Chart Colors with Palettes
- 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
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).
