Forum Discussion
Paginated Style Report
You can use Power BI Report Builder for free on your desktop to make your 50+ page pdf easily. You only need a premium capacity if you want to publish, subscribe, etc. You can connect to your published power bi dataset as the datasource (see the youtube link below), or you can connect to your local pbix file (see this post I wrote on that a while ago, but I recommend connecting to your published dataset.
https://www.youtube.com/playlist?list=PLx7LcKtN_gq-JVzM6L8xNNxX7kts-KflJ
https://hoosierbi.com/2018/11/21/paginated-reports-with-power-bi-desktop/
Regards,
Pat
Thanks mahoneypat, this is very helpful!
I'm not very familiar with PBI Report Builder and I have gone through some youtube videos you suggested. How do I setup so that I have the details of the User in one page?
Mysterously, there is also a blank page that appear on almost every other page. Has anyone experienced this before and know a way to fix it?
Thanks!
You should be able to set up a Group on the user field and then set up page breaks to get your desired results. FYI that Power BI Report Builder came from another product that has been around for a long time called SSRS Report Builder, and there is a lot of training content out there that applies. You can google specific questions with that product to find your answers. There is also a good YouTube series by Wise Owl too - https://www.youtube.com/playlist?list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU
Regards,
Pat
Thanks mahoneypat! The videos you recommended are very helpful!
Just to throw it out there: there is a bug in the PowerBI Report Builder where the table matrix wizard did not permit users to repeat column headers on new page. I had to overcome this by not using the wizard!