Forum Discussion
Export to PDF not Respecting Filters Selection Applied
Hi,
I've encountered an issue this morning on one of my report where users selection on slicer were not exported to pdf. The export to pdf just defaulted to no selection. After enabling and disabling report options one by one, I found the issue to be the 'Persistent Filter' option.
It is weird that it is only happening today. I had the option enabled since the report was published a year ago and the export to pdf worked flawlessly since until today. I have disabled the option and the export to pdf now works. There maybe a bug with the 'Persisten Filter' option on PowerBI service. I have reminded my users to hit the reset filter button on the report everytime they access the report.
Hi! Anonymous
The team is working on this issue and the fix will be deployed by end of this month.
The current workaround is to:
Select a dummy value on the filter options as the first choice and then select the actual filter value that they want the export to work with. Once they do this, they should be able to export with the desired filter value. This only applies when the customer has enabled the "Persistant filters" option on the PBIX file
17 Replies
Experiencing the same issue with filters selected not being respected when exporting. The exported report defaults back to all the values regardless of selected filter even though the live Power BI report is being filtered correctly. Has a ticket been raised on this issue as the work around metioned above is not an option.
I've raised a ticket. For me, turning off persistent filter worked. mlong , you may want to raise a separate ticket.
mlong - just so we're aware,
1. did you try the persistent filters troubleshooting?
2. are you passing URL filters?
Persistent filters is a work around but is causing a disruption in the day-to-day operations. As others have mentioned this was not an issue prior to 8/19.
A ticket is submitted to Microsoft with a link referencing this discussion.
Thanks everyone!
Hi! Anonymous
The team is working on this issue and the fix will be deployed by end of this month.
The current workaround is to:
Select a dummy value on the filter options as the first choice and then select the actual filter value that they want the export to work with. Once they do this, they should be able to export with the desired filter value. This only applies when the customer has enabled the "Persistant filters" option on the PBIX fileAnkitKukreja This is not the entire fix - if you have a single URL parameter... none of your manully added filters are respected on export.
Hi! stayingdusty
I didn't say this is a fix. This is a workaround, which might work and might not in some cases.
And I'm just sharing the info that I have. The fix will be available by next week, which means it would work as it used to previously.
Hi! Anonymous
There was a bug long time back on this. It could be the same. I would advise you to raise a ticket to MS.
I am having same issue with my users... been working fine for a report published for months, but now when I test it, I select and apply an "all pages" filter selection, the report looks as it should within the PBI Online interface, until I export to PDF/PPT (same effect for both formats) where the filter selection is ignored. (I get all results)
also, Anonymous did checking the box ( or unchecking the box) fix it for you (persistent filters option)? ...need to know what you meant by "disabling the option" so I can test as well.
stayingdusty I unchecked the persistent filter option on powerbi service and the export to pdf worked. I did enabled it again to test but it did not work, so I left it unchecked.
It is weird though as I did not have this issue before. I've already submitted a ticket to MS to investigate if it is a bug. In the meantime it's working for my report with persistent filter unchecked.
Anonymous thanks for the quick reply!
I have toggled the "Don't allow end user to save filters on this report." and tested both ways to no affect. I think I might have a different (but related) defect:
Defect: *No* filter selections are respected on export if *any* URL filters are passed.
To produce the defect:
- I go to a report via a URL that includes URL filters (i am aware that these do not work for export)
- The report loads correctly within PBI Online per the URL filter passed
- I manually select a filter option on a different field in the filters pane
- I export
- Result: The URL filters are not respected (this is expected) ✔️
- Result: The manually selected filter is not respected (this is a defect)
The work-around:
- I go to the report with no URL filters
- I manually select a filter option in the filters pane
- I export
- the manually selected filter option is respected
The work-around will not work for our users, I am just noting it here so others are aware.
ticket submitted - this was a bug that has been fixed. all good now. thanks!
To export your Power BI report to PDF with filters and slicers applied (needs a Power BI Pro license), see https://medium.com/bi-helper/automated-distribution-of-power-bi-reports-and-dashboards-25fde6c68af0.
