topic Re: Export to PDF current values using Power Automate in Developer

Export to PDF current values using Power Automate

magdanganeg — Fri, 21 Jul 2023 19:17:13 GMT

I wanted to export a page with the current values selected in Power BI using Power Automate. I already tried to use Power Automate, however it is only reflecting the unfiltered data (default values). What I need is to have the end-user select from multiple slicers, then have it exported into a PDF file and sent it to email. Is there a way to do it using Power Automate?

Re: Export to PDF current values using Power Automate

AmosHersch — Sun, 23 Jul 2023 07:51:03 GMT

Are your clients viewing the Power BI report embedded in your own app ? If so I believe you should capture the bookmark state using the JavaScript API and pass it to Power Automate to be used when calling the "Export to File" API

Re: Export to PDF current values using Power Automate

KiranHosakote — Tue, 24 Oct 2023 09:58:05 GMT

Hi @magdanganeg,

See if BI Helper https://bihelper.tech works for your use case.

BI Helper is a third-party SaaS tool that automates user-specific PDF generation and emailing (i.e., with slicers and filters applied) from Power BI.

BI Helper requires you to have one Power BI Pro (or higher) license. Your end-users can be internal or external to your organization and don't need Power BI licenses to receive their PDFs.