SQLBits 2024

Pagination made easy

An introduction and demonstration of Power BI Report Builder in action. This session aims to unveil the mysteries of pagination and explains why, sometimes, pagination is better.

Power BI Report Builder is often overlooked for it's shinier counterpart. In this short session, we'll look at common use-cases for pagination, demonstrate how to ingest data from Power BI Datasets, and learn how to 'paginate' our report using row groups. We'll use a simple trick to extract DAX from Power BI report visuals, and then paramertise our code for use within our Paginated report.