Forum Discussion

Mary_aj's avatar
Mary_aj
Frequent Visitor
4 years ago
Solved

Power BI RS and export table to PDF

Hi All, I use Power BI Report Server May 2020 Maybe, Do you have any ideas or solutions on how to export a table to PDF format?   
Export PDF
Report Server
  • whereismydata's avatar
    whereismydata
    4 years ago

    As far as I know this is not supported by PowerBI RS but supported by PowerBI Service.

     

    What you can do:

    • There is a general print option; create a page with this table only, maybe also hide elements that you do not want to be printed. Then create a print button that links to this page. This way you only see this one table on the print
    • Another solution would be to use the report builder since it allwos exporting to other formats as well like XLSX, PPT, PDF...
    • A more complex solution would involve power automate or maybe some sort of custom scripting that listens to a http request and then pulls the data from a given database and safes the table. But I don't think this is the most userfriendly and developer friendly option
m_aj's avatar
m_aj
Frequent Visitor
4 years ago

whereismydata  Maybe you also know

if I have a table with 8 columns and export it to PDF using Report Builder, Report Builder can change the size of this table automatically?

Because I got pdf file but 4 columns on the first page, the next 4 columns are on the second page.

Thanks)  

whereismydata's avatar
whereismydata
Icon for Resolver IV rankResolver IV
4 years ago

hm, report builder is pretty static. I'm not shure if you can do anything dynamically.

But since you have a table with a fixed number of columns I think you can design the report so that all information is on one page? maybe it help to play around with pagesize or orientation.