Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to 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 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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 ...)
@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
hi @amitchandak,
is that only power bi premium can used paginated reports?
power bi pro cant used is it?
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.
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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |