Pagination made easy

on YouTube ↗20m

" summary

Power BI Report Builder connects to a Power BI semantic model, copies DAX from a Power BI visual, and uses a single-cell list to turn row groups into pages; the demo produces paginated PDFs (one page per customer) and Excel with one sheet per departure country by setting the page name → Excel tab property. It shows using a list box row group, exporting templated letters/bills, and injecting a user-selectable parameterized DAX to filter which records are paginated.

AI-written summary · about

" chapters (10)

1. 0:00Pagination and Report Builder
2. 1:52Effective Report Builder use
3. 3:39Report Builder for pagination
4. 5:47Demo: Report Builder + Power BI
5. 10:00Pagination with list boxes
6. 11:45Excel tabs via pagination
7. 13:54Formatted customer letters
8. 14:37Parameterized reports
9. 17:56Pagination use cases
10. 18:38Q&A

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 54mData Visualization with Power View and the Tabular ModelJen Stirrup · PASS Business Analytics Conference 2013
• 01h 03mFrom Data to Insight – Views from Microsoft FinanceMarc Reguera · PASS Business Analytics Conference 2013
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 48mDon't be scared with Hybrid, they are only tables…Bruno Mairos, Maria Gabriel · SQLBits 2023
• 11mPower BI - Call REST APIIuliana Tuhasu · SQLBits 2023