Export Power BI App content as pdf in one shot

[MS4]

Dear community,

background: my power bi app consists of several pbix. files.

issue: using the usual export function (export --> pdf) I get only those pages related to the specific pbix.file.

target: To export/print the whole content of the app(i. e. all pages incl. subpages) in one shot.

can you please help here?

thank you  a lot for your help and support

BR

Matthias

[MS4]

HI @ibarrau ,
thank you for your reply. Your solution sounds good. However from a citizen developer´s point of view(no admin right, no access to the REST API) your proposal is unfortunately not feasbile. 

Are you aware of any solution withi PBI that could help(apart from PDF prinintg page-by-page and merging them via a pdf tool)?

Thank you

BR

Matthias
 

[ibarrau]

Hi. Sorry but there is no other way. As a citizen developer you could build a report export with automate like this: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export

The thing is that in order to do it for all reports of the app once, you will need to understand the API.

As an alternative you could build a power automate flow for each report and run them at similar times. That way you could have all the pdfs together exported automatically just being a citizen developer. Check the link out maybe that helps. Remember you need a power bi license by capacity to export this way.

I hope that helps,

[ibarrau]

Hi, that's not possible within the Power Bi Service UI. The only way to accomplisg this would be using the Power Bi Rest API. You could also use Power Automate (to read the API) in order to create flows that let you export.

Consider that exporting pdf files with API it's only available for Capacity Licenses. You can only do it with Premium Capacity, Embedded or Fabric. If your workspace is Pro or PPU then you can't.

1- First, the idea would be running a get reports from an app: https://learn.microsoft.com/en-us/rest/api/power-bi/apps/get-reports

2- Build a loop to run the following request for each report

3- Export the pdf for current report of the loop: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group

That would be the automated way, you can also always run one by one manually.

I hope that helps,