Forum Discussion
Power automate dynamic export
I have a dashboard with some different visualization for several companies financial data. In the dashboard there is a column where I can choose which companies data to include in the current visualization. By default it shows the data which is sum for all the companies. I need to export the dashboard to the pdf, and also to generate pdf with this dashboard for each company. I am trying to use power automate for that, in the flow i initialize the array with companies names in it, pass that array to the repeat for each loop, and do the export function within the loop. I pass the current value of the loop to the export function.
With this method it generates me a pdf with the same dashboard given 5 times, the dashboard is the one with the sum of values for all the companies.
What shall I do to make it generate pdf report with different dashboards per company?
Thank you.
you need to check the output of the trigger but it's likely something like
item()?['Column1']
20 Replies
You need to provide the Report Level Filters. Make sure that column actually controls the data model.
Hi Bromik
The Power Automate based solution for report bursting (PDFs sliced or filtered on a parameter like company, product, branch, etc) is complicated and not very scalable as the slicer values increase.
If you are open to using third-party solutions, take a look at BI Helper https://bihelper.tech, an easy to use SaaS application that automates the generation and emailing of user-specific PDFs (with filters and slicers applied). It is secure, scalable and reliable and requires a single Power BI Pro / PPU license.
It doesn't require Power Automate or any other tools, and can be easily set up and run by a business user.
Could you provide the solution that best worked?
