0
0
Power BIbi_tool~8 mins

Publishing paginated reports in Power BI - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Publishing paginated reports
Goal: Understand how to publish paginated reports in Power BI

This dashboard answers: How can you publish a paginated report to the Power BI service and verify it is accessible?

Sample Data: Report Publishing Status
Report NameFile Size (MB)PagesPublish StatusLast Published Date
Sales Summary2.55Success2024-06-01
Inventory Details3.18Success2024-06-02
Customer Orders1.84Failed2024-05-30
Financial Report4.010Success2024-06-01
Employee Data1.23Success2024-06-03
Dashboard Components
  • KPI Card: Total Reports Published
    Formula: Count of reports with Publish Status = 'Success' (Result: 4)
  • KPI Card: Average Report Size (MB)
    Formula: Average of File Size for all reports (Result: 2.52 MB)
  • Bar Chart: Number of Pages per Report
    Shows each report on X-axis and number of pages on Y-axis
  • Table: Report Details
    Shows all columns from sample data for detailed view
Layout
+----------------------+-----------------------+
| Total Reports: 4     | Average Size: 2.52 MB |
+----------------------+-----------------------+
|                                      Bar Chart                                      |
|                        (Pages per Report)                                          |
+-----------------------------------------------------------------------------------+
|                                Report Details Table                                |
+-----------------------------------------------------------------------------------+
Interactivity

A filter for Publish Status allows users to select 'Success' or 'Failed'. When applied:

  • KPI cards update to reflect counts and averages only for selected status.
  • Bar chart updates to show pages only for filtered reports.
  • Table shows only reports matching the filter.
Self Check

If you add a filter for Publish Status = 'Failed', which components update and what do they show?

  • KPI Cards: Total Reports Published shows 1; Average Report Size shows 1.8 MB.
  • Bar Chart: Shows only 'Customer Orders' with 4 pages.
  • Table: Shows only the 'Customer Orders' report row.
Key Result
Dashboard showing publishing status and details of paginated reports in Power BI.