Use pbix model in Paginated Report

[shyammayhs]

Hi guys, I would like to use the same data model or dataset I have used in a Power BI report in a paginated report. Is this possible? What are my options in creating a pdf version of the report?

Thanks guys!

[ponnusamy]

@shyammayhs : Yes, you can. Just go to the dataset and click three dots , you will get an option as "Create Paginated Report". This will download an "rdl" file for you. You can edit using Report Builder and publish it as paginated reports.

For PDF Version:  You can actually subscribe the standard Power BI report and have it emailed as PDF attachment or export as PDF from Power BI Service with out Paginated report. However, it will only send you the screen shot of the report (Page view) and not optimized for paginated.  I would recommend you to create paginated report if you have table visuals and the data runs into several pages.

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.

[shyammayhs]

Hi @ponnusamy, thanks for your reply. If the .pbix dataset has multiple tables, measures etc. How do I approach this? because in Paginated reports, the query was loading the data as one table? is this okay to do? and how is the data model managed then?

[ponnusamy · Accepted solution]

@shyammayhs :  Please see my response below 

If the .pbix dataset has multiple tables, measures etc. How do I approach this? because in Paginated reports, the query was loading the data as one table?

You can connect to PowerBI Dataset and all the tables that are available on PowerBI dataset will be available for you in the paginated report through 'Report builder'. You can pick and choose what you want in your paginated reports.  You can also add any additional measure or columns if you want or you can simply use all the measures and column that get imported from dataset.

If you have multiple tables in your PowerBI Dataset, all of them will be available for you (see the pic below)

is this okay to do? and how is the data model managed then?

The data model (Dataset) can still be maintained using Power BI Desktop to keep the source consistent. However you will have flexibility to add certain things using report builder as well. In short, you can simply maintian using Power BI Desktop which will support for Power BI report and Paginated Report.

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.

[shyammayhs]

Thanks @ponnusamy I will have a look into your solution and let you know if it worked for me.

[ponnusamy]

@shyammayhs : Get the latest Report builder, Microsoft has released a new version.