Exporting a Report

[kp_wood13]

Is it possible to export a full report to PDF or Power Point from a Power BI app? What we're seeing is it essentially exports an image of what fits on the screen, so if there is a table visual with a scroll for instance, the data below the scroll line is not exported. Example output in the picture.

 

[v-yueyunzh-msft]

Hi , @kp_wood13 

According to your requirements, you want to implement "export a full report to PDF or Power Point from a Power BI app", which means you want to batch export all reports from a workspace to PDF or PPT files, right?

If this is the case, in the official Power BI feature offering, there is no such function in the UI interface for the time being, but there is a way to export reports to PDF using the Rest API, if it is suitable for your business scenario, you can consider using:

Here are the steps to export a file to PDF using the rest API:

First you can use this rest API to start the export process, in the request body you can define the type of export file:

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Then you can use the report ID and export ID to fill in the parameters into the URL of this rest API to get the status of the export task:

Reports - Get Export To File Status In Group - REST API (Power BI Power BI REST APIs) | Microsoft Le...

Finally, if the status gets "Succeeded", you can use this rest API to get the output file of the export task:

Reports - Get File Of Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft L...

If you can successfully run these three APIs in the official documentation, you can try to use PowerShell or PowerAutmate as a tool to combine these three APIs to populate the report ID included in the app in the workspace as a parameter to implement the batch export function:

Get started with Power Automate (contains video) - Power Automate | Microsoft Learn

Working with PowerShell in Power BI | Microsoft Power BI Blog | Microsoft Power BI

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[kp_wood13]

Not quite, I understand automating the export process. If you look at the image I attached you can see scroll lines along the right side and bottom of the table visual. I'm wanting to get the full dataset represented in that table in a report. I would assume expanding the visual so the whole data set is visible would be the only way to accomplish this from Power BI?

[v-yueyunzh-msft · Accepted solution]

Hi , @kp_wood13 

Yes, one way to get the full dataset represented in a table visual in a report is to expand the visual so that the whole dataset is visible.

For more information, you can refer to :
Export reports to PDF - Power BI | Microsoft Learn

You can also use the "Export data" feature to export the data from the visual to a CSV file.

Or you can try to use the "Paginated report" feature.

For more information, you can refer to :

What are paginated reports in Power BI? - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly