Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
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,
Happy to help!
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,
Happy to help!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.