Forum Discussion
PowerBI report into multiple PDFs
Hi folks,
Hope you are doing well.
I have a power bi report with country filter/slicer. I need to generate pdf reports for each country.
Can I achieve this using power automate or do we have any other solution to achieve this? I need to do it on a monthly basis.
Thanks in advance.
5 Replies
i will recommend the power bi report server to do this, you can also set the parameters dor dynamically getting the outcome.
If this helped, Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
https://instagram.com/analytic_pulse
https://analyticpulse.blogspot.com/subscribe to Youtube channel For fun facts:
https://www.youtube.com/@CogniJourneyGuy in a Cube did a video on this recently with one of the new Power Automate actions: https://youtu.be/QzG7DFaAYng?si=oh6t8omcr40qqxlM
My understanding is paginated reports are the go-to for auto-generated PDF reports in the PBI service. You might be able to "ape" it using Power Automate Desktop essentially recording the manual export actions, but paginated is the "official" way to do it right now in PBI.
Hi,
If you are open to third-party solutions, see if BI Helper https://bihelper.tech works for you.
BI Helper is a popular and easy to use SaaS application that generates and emails user-specific PDFs (with filters and slicers applied). It only needs a Power BI Pro license, and doesn't require Power Automate or any other component.
