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.
Resolver IWhat I mean by URL is the power BI service URL after passing filter values within the URL header.
I did tried to passed in the rpeort filter section at the time of "Exporting a PBI report" but Power automate couldnt apply those column value back into the power Bi report into the slicer section to refresh the visual in the report pages.
Super UserIt 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.
- rohithkothaneth
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.