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.
Super UserYou didn't apply the report level filter(s).
Resolver IMy report page visuals are driven by the slicer value which is also based on the same column that i have passed to the power automate. I tried to pass the value as a filter in the URL, but the slicer doesnt get chnaged. It needed be picked manually to get ti changed. Is there a way for me to interact with the slicers via any means.
I tried addinga report filter but the slicer didnt get changed.
- lbendlin
I tried to pass the value as a filter in the URLWhat URL? This needs to be in the Power Automate export step. Make sure to specify both the table and the column name, and to escape special characters. (Like you would do in the URL)