Forum Discussion
Power BI Report Export PDF for 500 Companies using Power Automate
Hello,
I need some help in automating Power BI Report export to PDF for 500 company and saving those PDF's to OneDrive or Sharepoint location on monthly basis. I created a simple Power Automate flow that is giving me the Power BI Export in 1 PDF which has aggregate sales for all companies. I have my company column in filter on all pages and I want some guidance on how to pass this filter in Power Automate flow that I can get 500 PDF's instead of 1 PDF.
For testing purpose I passed just one company in ReportLevelFilters Filter using this expression "Table/Company eq 'abc'" and it gave me pdf for just one company.
Here is my simple Power Automate Flow.
Any help is really appreciated.
Thanks.
Hi Anonymous
What you will need to do is to store a list of the companies or get a list of the companies to be exported into an Excel file.
Then you will read the data from your Excel file.
Next you will create a "Apply to Each" in Power Automate which will loop through the Excel file and for each file it will use the Company name in the filter and then export the report.
Here is a working example: Extract information in Excel using Power Automate - Azure Cognitive Services | Microsoft Learn
2 Replies
- GilbertQ
Super User
Hi Anonymous
What you will need to do is to store a list of the companies or get a list of the companies to be exported into an Excel file.
Then you will read the data from your Excel file.
Next you will create a "Apply to Each" in Power Automate which will loop through the Excel file and for each file it will use the Company name in the filter and then export the report.
Here is a working example: Extract information in Excel using Power Automate - Azure Cognitive Services | Microsoft Learn
KiranHosakotePost Patron
Hi Anonymous,
The Power Automate solution will work but it requires you to have Premium capacity and to manually manage your list of filter values each time you want to run your report.
To automate this process, see if BI Helper https://bihelper.tech meets your use case to generate user-specific PDFs (with filters and slicers applied). Specifically, for automated slicer / filter input (especially useful for your use case of a large number of recipients), refer to the tutorial at https://medium.com/p/bfebd39d4c84.