Power Bi exports to PDF how to get all the data?

[dcormiernj]

I have two questions about the power bi export to pdf. And I am wondering if this is a limitation of BI or is there a trick i dont know yet!

1. I have a visual with a lot of columns, when i export it to pdf it exports to several pages instead of fitting all columns on one page. Is there anyway to tell BI to export all columns to fit page? is there anyway to tell it to export at 50% or whatever it takes so all columns are on one pdf page?

2. I have a visual that includes a formatted table of many rows. in the visual i can scroll up and down to see the data and the total is always showing at the bottom. when i export to pdf or powerpoint it only exports the data i can see at the time of export. is there anyway to to tell BI to export the report with all of the data?

are these limitations to BI? or am i doing something wrong? I am trying to create an invoice for example in BI then export to pdf to send to customer. but I cant do that.
Any IDeas?
Thank you

[AlexisOlson · Accepted solution]

#1 is might be possible but I don't know enough to advise well.

#2 is not currently possible. Power BI is not designed for this sort of thing. It will export whatever you see on the page, not an expanded version of it. The Power BI Report Builder tends to be a better tool for this sort of paginated reporting. This is a very different tool with a variety of advantages and disadvantages.