print data from power bi

[space83]

hi guys, below is example of my report:

How can i print this report to printer in A4 size and list all the record on physical paper (of course it will required more pages), same like traditional reporting?

[AllisonKennedy]

@space83  Power BI isn't great with printing, you can use Paginated Reports for printing tables split across multiple pages, or you could try to build a parameter that maybe batches the results and duplicate the page. You'd need to create a slicer that sets 'Page Number' and change that for each page. Filter the table visual to only show results based on page number selection. This will require a ranking or unique id.

For example, create a new parameter for page number with range from 1 - 10 (or however high you need it).

Create a measure for total records per page:

ItemsPerPage = 10

Then create a measure that calculates Min and Max ID: 

MinIDtoDisplay = (SELECTEDVALUE(Parameter[PageNumber]) - 1 ) * [ItemsPerPage] 

MaxIDtoDisplay = (SELECTEDVALUE(Parameter[PageNumber])  ) * [ItemsPerPage] 

Then set a filter on the table visual for Table[ID] is greater than MinIDtoDisplay and is less than or equal to MaxIDtoDisplay.

Then duplicate the page and update the page number slicer for each page. 

Finally print. 

[Syndicate_Admin]

I had a private question to give more information and an example, then here you have the example pbix to use a DAX filter for pages (sorry for my Spanish ...)

Display Items =

WHERE _MinIDtoDisplay = (SELECTEDVALUE(PageNumber[PageNumber]) - 1 ) * [ItemsPerPage]

WHERE _MaxIDtoDisplay = (SELECTEDVALUE(PageNumber[PageNumber]) ) * [ItemsPerPage]

RETURN

COUNTROWS(

FILTER(

'Paginated Demo',

'Paginated Demo'[Index] <= _MaxIDtoDisplay && 'Paginated Demo'[Index] >= _MinIDtoDisplay

))

[amitchandak]

@space83 , you can export it to csv or pdf(from service) and print.

Or you can use power bi report designer to create paginated reports for printing

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-b...

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-faq

[space83]

hi @amitchandak,

is that only power bi premium can used paginated reports?

power bi pro cant used is it?

[v-yingjl · Accepted solution]

Hi @space83 ,

A major advantage of paginated reports is their ability to print all the data in a table, no matter how long. You can publish and share paginated reports in your My Workspace or in workspaces, as long as the workspace is in a Power BI Premium capacity. Power bi Pro license cannot use it currently.

In addition, paginated reports is built based on power bi report builder instead of power bi desktop, you can refer this tutorial to create a paginated report: Tutorial: Create a paginated report and upload it to the Power BI service 

If you do not want to use paginated reports to print all data from table in power bi service, you need to export it to .csv or .xlsx file and print it. Export to pdf or print directly in power bi service could not get all of data in the visuals.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[space83]

hi @v-yingjl ,

I dont think import to csv is good solution especially the one who use matrix report.

u will not get the exact report what has shown in power bi dashboard.

others than power bi premium, what others solution can use to fix this issue?