Power BI Report Builder for Developers

• Design paginated reports using Power BI Report Builder.
• Create and configure embedded data sources and datasets.
• Work with Power BI semantic models and other supported data sources.
• Create tables, matrices, charts, and other report layouts.
• Apply filters, sorting, grouping, and expressions.
• Create and manage report parameters.
• Build interactive and drillthrough reports.
• Control report pagination and page layout.
• Export reports to formats such as PDF, Excel, Word, CSV and XML.
• Publish paginated reports to Power BI Service.
• Configure report subscriptions and distribution.
• Use deployment pipelines with paginated reports.
• Optimize report design and performance.

Module 1: Introduction to Power BI Report Builder

• Introduction to Power BI Report Builder
• Understanding paginated reports
• Paginated reports vs Power BI interactive reports
• Power BI Report Builder interface
• Report Data pane
• Report design surface
• Parameters pane
• Properties pane
• Grouping pane
• Report definition files
• Understanding RDL
• Creating and saving reports

Module 2: Data Sources and Datasets

• Understanding data sources
• Understanding datasets
• Creating embedded data sources
• Creating datasets
• Connecting to SQL Server
• Connecting to Azure SQL
• Connecting to Oracle
• Connecting to Power BI semantic models
• Connecting to Analysis Services
• Connecting to OData
• Creating dataset queries
• Managing credentials and connections

Module 3: Creating Tables, Matrices and Lists

• Creating table reports
• Creating matrix reports
• Creating list reports
• Adding fields
• Formatting report columns
• Grouping data
• Sorting data
• Aggregating data
• Row groups
• Column groups
• Nested groups
• Tablix structure
• Repeating headers

Module 4: Report Layout and Formatting

• Page size and orientation
• Margins
• Report body
• Headers and footers
• Page breaks
• Page names
• Text boxes
• Images
• Lines and rectangles
• Borders and backgrounds
• Fonts and formatting
• Precise positioning
• Print-ready report design

Module 5: Expressions and Calculations

• Introduction to expressions
• Expression syntax
• Calculated fields
• Conditional formatting
• IIF
• SWITCH
• String expressions
• Date expressions
• Numeric expressions
• Aggregate expressions
• Report item expressions
• Expression-based formatting
• Using expressions with parameters

Module 6: Parameters and Filters

• Report parameters
• Dataset parameters
• Query parameters
• Parameter data types
• Default parameter values
• Available parameter values
• Multi-value parameters
• Cascading parameters
• Parameter-based filtering
• Filtering datasets
• Filtering report data
• Parameter-based report presentation

Module 7: Charts and Visualizations

• Creating charts
• Column charts
• Bar charts
• Line charts
• Pie and doughnut charts
• Area charts
• Scatter charts
• Funnel charts
• Treemap charts
• Chart formatting
• Chart expressions
• Chart parameters
• Data labels
• Legends
• Titles and axes
• Sparklines
• Indicators
• Gauges

Module 8: Advanced Grouping and Interactivity

• Advanced grouping
• Expression-based groups
• Group hierarchies
• Drilldown
• Drillthrough reports
• Subreports
• Nested data regions
• Interactive sorting
• Show/hide functionality
• Document maps
• Bookmarks
• Navigation actions
• Hyperlinks

Module 9: Maps and Geographic Reports

• Map reports
• Map wizard
• Spatial data
• Geographic data
• Map layers
• Color maps
• Bubble maps
• Heat maps
• Bing map tiles
• ESRI shapefiles
• SQL spatial data

Module 10: Pagination, Rendering and Export

• Understanding pagination
• Controlling page breaks
• Page numbering
• Page names
• Print layout
• Rendering extensions
• HTML rendering
• PDF rendering
• Excel rendering
• Word rendering
• CSV export
• XML export
• MHTML export
• Optimizing reports for export

Module 11: Publishing and Managing Paginated Reports

• Previewing reports
• Publishing to Power BI Service
• Power BI workspaces
• Report permissions
• Dataset permissions
• Managing published reports
• Configuring data-source credentials
• Gateway requirements for on-premises sources
• Report subscriptions
• Email distribution
• Deployment pipelines
• Report lifecycle management

Module 12: Developer and Enterprise Reporting Practices

• Report development workflow
• RDL report definitions
• Reusable report design
• SSRS report migration
• Power BI semantic model integration
• Report validation
• Performance considerations
• Enterprise reporting scenarios
• Production-ready paginated reports
• Multi-page operational reporting

2 Days

Course Completion Certificate by Network Binary

• Install and configure Power BI Report Builder.
• Create an embedded data source.
• Create and configure datasets.
• Connect to SQL Server and Power BI semantic models.
• Build a basic table report.
• Create matrix and grouped reports.
• Apply sorting, filtering and aggregation.
• Create calculated fields and expressions.
• Apply conditional formatting.
• Create report parameters.
• Build cascading and multi-value parameters.
• Create interactive charts.
• Create drilldown and drillthrough reports.
• Create subreports and nested data regions.
• Create document maps and bookmarks.
• Build geographic map reports.
• Configure page breaks and page numbering.
• Design a pixel-perfect multi-page invoice.
• Preview and validate reports.
• Export reports to PDF and Excel.
• Publish paginated reports to Power BI Service.
• Configure report data-source credentials.
• Create a deployment pipeline for paginated reports.

• Power BI Developers
• BI Developers
• Data Analysts
• Business Intelligence Professionals
• Reporting Developers
• Data Engineers
• Professionals responsible for operational reporting
• Professionals who need pixel-perfect or print-ready reports

• Experience working with relational data sources such as SQL Server, Oracle or Azure SQL.
• Familiarity with Power BI semantic models and dataset connectivity.
• Understanding of paginated reports, datasets and expressions.
• Ability to create and manage data connections and queries.
• Working knowledge of Windows 10, Windows 11 or Windows Server 2016+.
• Basic understanding of .NET Framework 4.7.2 requirements.