Forum Discussion
Helper IVprint data from power bi
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?
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.
6 Replies
- amitchandak
Super User
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-faq
space83hi amitchandak,
is that only power bi premium can used paginated reports?
power bi pro cant used is it?
v-yingjlCommunity Support
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.
- AllisonKennedy
Community Champion
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_AdminAdministrator
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]
RETURNCOUNTROWS(FILTER('Paginated Demo','Paginated Demo'[Index] <= _MaxIDtoDisplay && 'Paginated Demo'[Index] >= _MinIDtoDisplay))
