Introduction to Power BI Paginated Report Builder

Download the Power BI Report Builder tool from Microsoft's site, install with default settings, and launch it to create your first report.

Explore the Power BI paginated report design window, access data sources and data sets, use the ribbon and insert tools, and export reports.

Configure a data source in Power BI paginated report builder by connecting to a local SQL Server using Windows authentication and testing the Adventure Works database.

Rename dataset columns to friendlier names by right-clicking a field and opening the dataset properties, remove words like English, then click okay to apply changes.

Create a sales report by inserting a table and a matrix in Power BI paginated report builder, dragging sales amount by product category and subcategory.

Group and sum the product category values in a matrix, then expand to reveal sales details by clicking the plus sign, while hiding a column via visibility.

Group and expand columns in a matrix to display sales by country and state in a Power BI paginated report, creating an easy, expandable, tab-like view.

Explore expressions in Power BI paginated reports to calculate converted sales amounts with the end-of-day rate, and learn to perform line-by-line math for accurate results.

Explore how to build and use expressions in Power BI Paginated Report Builder, applying math, text functions like Len, and date functions to dynamic table columns at runtime.

Add row and column totals to a matrix in Power BI paginated report builder, display grand totals for euro groups and column groups, and format tables to fold columns.

Apply conditional formatting in a Power BI paginated report by using expressions to color cells: green for sales over 2500, red for under 1000, and white otherwise, with currency formatting.

Assign actions to text boxes to link to subreports, bookmarks, or new URLs. Hyperlinks open in a different window and enable drill-through interactivity.

Learn to convert a field from text to currency and use custom formatting and expressions to format values, control decimals, and apply rounding in Power BI paginated reports.

Configure matrix properties to control visibility and sorting, repeat headers on each page, and keep the report on a single page while sorting product subcategories.

Style the matrix in Power BI Paginated Report Builder by applying formatting, removing extra categories, bolding and centering headers, and italicizing totals for a clearer product and region view.

Insert a pie chart, create a chart data set from a SQL Server source with sales-by-product data, map values and categories, and show percentage labels.

Create and customize bar and line charts in Power BI paginated reports, manage data sets and axes, apply sorting, and add a target line for actual versus target.

Explore creating a scatter chart in Power BI paginated report builder by mapping year-quarter on the bottom axis and displaying bubbles for unit price and order quantity.

Create a report with the map wizard to visualize sales on a map, using shapefiles and a data layer with a SQL Server spatial query, and bubbles representing sales.

Add a gauge chart to a Power BI paginated report by querying SQL Server and inserting country, year, and amount, with a dynamic max to visualize targets.

Create a new sparkline dataset from SQL Server and insert a sparkline in the matrix to visualize sales trends over time.

Build a KPI enriched paginated report by connecting to a SQL Server source, creating a dataset and matrix, and adding a gauge and stoplight indicators with conditional formatting.

Explore adding parameters to a paginated report builder to drive dynamic results with cascading country and state choices, using parameter data sets and on-the-fly filtering of the primary data set.

Embed a subreport into your paginated report using the insert command, configure its properties, and pass parameters from the main report while considering visibility and deployment.

Add headers and footers, insert images and text boxes, and polish a paginated report with a company logo and current date for a professional, clean presentation.

Learn how to run and export your paginated report, then open the Excel export to manipulate tables with formulas while charts become editable images, preserving the report layout.