topic Re: printing multipage tables in Developer

printing multipage tables

mattpharma — Thu, 17 Nov 2016 20:11:31 GMT

Hi, does anyone have a solution for printing a table in Power BI that is multiple pages? I have a table that does not display all data on the screen so you have to scroll down on the screeen. When you print to hard copy or pdf you only get 1 page. Any work arounds/solutions would be much appreciated. Thanks for the help.

Re: printing multipage tables

Eric_Zhang — Fri, 18 Nov 2016 09:54:18 GMT

@mattpharma

How did you print the report? Isn't the built-in print working?

Re: printing multipage tables

mattpharma — Fri, 18 Nov 2016 12:15:10 GMT

its not a dashboard...its a table. so i click file then print. if i have a table as a dashboard does it print more than one page of the table?

Re: printing multipage tables

Eric_Zhang — Tue, 22 Nov 2016 10:09:59 GMT

@mattpharma

I don't have a printer at hand, so try it out by yourself.

Re: printing multipage tables

jderekc — Tue, 30 May 2017 19:55:32 GMT

Hi,

I don't typically like digging up old threads but I thought that since this thread wasn't marked as resolved, I'd ask the same question as the OP. Can you print a report that has a table that would span multiple pages? It looks like you can only print what is visible in the report at the time of printing, excluding scrolling down. Not sure if this is a current feature or perhaps an idea? Sorry again for digging up an old thread, but I wasn't sure if I should duplicate this thread or not.

Many thanks,

Derek

Re: printing multipage tables

winni01 — Wed, 23 May 2018 15:12:22 GMT

STill looking for a solution to this. Anyone?

Re: printing multipage tables

winni01 — Wed, 23 May 2018 15:14:41 GMT

Hi all, I am looking for a solution to this issue as well. I have a report that has a long table, I want it to print to multiple pages and repeat the header, suggestions?

Re: printing multipage tables

JorgenHNO3 — Wed, 20 Jun 2018 12:21:16 GMT

I'm also looking for this. Quite annoying

Re: printing multipage tables

Anonymous — Fri, 13 Jul 2018 09:20:56 GMT

I'm also looking for a solution to this one, although I'm exporting to ppt instead of printing, but same issue.

Re: printing multipage tables

askhor — Tue, 17 Jul 2018 03:47:36 GMT

I don't think it is possible in PBI currently. What I am doing is to export the table to excel, then print from the excel.

Re: printing multipage tables

Anonymous — Tue, 17 Jul 2018 08:18:49 GMT

We've ended up creating a workaround by using dynamic indexes and rankx to at least be able to print for example the first 20 rows on page 1, 21-40 on page 2, 41-60 on page 3 etc.

In our case we have user feedback so usually contains a lot of commas, so export to csv doesn't work well.

Regards,

Matt

Re: printing multipage tables

Anonymous — Thu, 27 Sep 2018 15:08:30 GMT

That wouldn't work in all cases, if we didn't know the number of rows that would be displayed right?

I have data that can have from 10 to 100s of rows depending on the filters selected, in this case I might be showing empty pages if less data is there. Did you have any work around for this?

Re: printing multipage tables

Anonymous — Fri, 28 Sep 2018 09:55:37 GMT

@AnonymousThat's correct what you say, we have empty pages that are sometimes filled and sometimes not, depending on the amount of rows. We've not found another workaround. Our client requirement is to have a pdf report anyway, so we just manually hide the empty pages so they're not exported to the pdf, and we also therefore don't have the problem with filters.

Sorry can't be of more help!

Regards,

Matt

Re: printing multipage tables

Anonymous — Sat, 29 Sep 2018 07:00:38 GMT

Makes sense. Thanks!

Re: printing multipage tables

Anonymous — Wed, 24 Oct 2018 22:03:53 GMT

How is this still not resolved?

Re: printing multipage tables

Anonymous — Thu, 11 Jul 2019 08:17:30 GMT

I'd also like to see this resolved

Re: printing multipage tables

Anonymous — Thu, 05 Mar 2020 06:32:37 GMT

Hi, no solutution to this yet, I assume? Would be great to have this solved!