Forum Discussion
Resolver IDynamically export the report pages to PDF based on slicer value which is driving a Power Bi report
It works for me - check your data model and your table and column spelling. As you mentioned you can use the report URL for checking that it filters correctly.
It was not working because, i had set the slicer to have a mandatory "Single selection" turned ON. Once I remove that, I was able to successfully test this by passing filter value as a header in the URL. Same was dynamically generated in Power automate flow and passed within the filter parameter section for the "Exporting a PDF of the PBI report" connector in Power autiomate.
https://app.powerbi.com/groups/******/reports/******/ReportSection*****?filter=<Table name>/<column name> eq '<column value>'
Thank you for confirming that this solution works.
Helper IVHi lbendlin - Can you please help me like, I also have a similar requirement where If I select 3 customers in my filter, I should be able to export 3 differenct PDF's (1 per each customer). I'm able to do for each customer (single selection) but I'm not able to run the loop in Power Automate to execute one by one.
I have also posted my query here: https://community.fabric.microsoft.com/t5/Desktop/Export-the-Power-BI-report-as-PDF-format-for-selected-customers/m-p/3977864#M1271169
Any thoughts around this?
akhilduvvuru I've the filters too and similar situation but not able to extract PDF. How were you able to extract the PDF for 1 customer? Could you please share with me your flow?
Many thanks
Banashree
- akhilduvvuru
I have the names and email ids in another excel file. I want power automate to pick up each name from the excel and filter the page, extract the pdf and send the pdf via email. The email id is present as a 2nd column in the excel file. How can i instruct power automate to do that?
- lbendlin
Super User
Put your customer names in an array, then loop over the array and in each loop take the current customer name value and use it as a report filter for the extract request.
- akhilduvvuru
Thanks for your response lbendlin - I don't know I think I'm missing something and I'm not able to get that. Can you please share, if you have any screenshot for the same?
- lbendlin
