Forum Discussion
Advocate IPowerBI - Exporting reports to PDF or PowerPoint losing filtration on report.
I just ran a quick test and export to PDF with respecting filters appears to be fixed. This issue has happened at least once or twice per year for the last 3 years.
Advocate IThe issue of Power BI not respecting slicers when exporting to PDF is still persitant as of 10/09/2023. This has been ongoing since 10/02/2023. Raising a new support ticket.
A workaround we've found is to disable the option "Don't allow end user to save filters on this report." With this option disabled, filters are honoured by the PDF export.
Microsoft closed our support ticket saying for now this was expected behavior.
KrakenI don't understand how this could be true: "Microsoft closed our support ticket saying for now this was expected behavior" considering that there is a button which the user selects if they want current/default values?
To quote the response we had
As discussed, export to PDF is working as expected when persistent filters is disabled from report settings in power bi desktop and published.
This is expected behavior of this feature in service with latest releases.
Please be assured that this behavior is already reported to product team as feedback.They are working on it to bring back to its old behavior but there is no ETA as of now.
Let us know if you have any further queries , we are happy to help you on the same.
We don't want to disable "Don't allow end user to save filters", as it results in people leaving the filters all over the place for the next person. Interestingly if you export to PowerPoint the filters stay, so that suggests it isn't expected behaviour but a bug on the .pdf side?
- we4get
Totally agree - I've responded on my ticket to advise that this works as a temporary workaround but not accepted as a solution for the reasons you state