Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
space83
Helper IV
Helper IV

print data from power bi

hi guys, below is example of my report:

print-reporting.jpg

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?

1 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.

View solution in original post

6 REPLIES 6
AllisonKennedy
Super User
Super User

@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. 


Please @mention me in your reply if you want a response.

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 ...)

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
))
AllisonKennedy_0-1678265947828.png

amitchandak
Super User
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-report-builder-power-b...

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.