Forum Discussion
Export to PDF from Service not respecting Current Value selections
When users try to export reports to PDF from the Power BI Service, they are unable to get the export to reflect their filter selections, bookmarks, etc. It shows the default value, even when Current Values is selected in the dropdown. The "Exclude hidden pages" option is working. This issue was replicated across multiple reports, in both workspaces and apps. It is working properly if the .pbix file is opened in the desktop application.
After further research, it looks like this is affecting reports that use buttons linked to bookmarks to hide/unhide visuals. For example, some reports have multiple tables on a page, and a user uses the bookmark to select which table they'd like to see. Filters are respected on export before the user selects a button, but not after. Other reports are now exporting as expected.
20 Replies
had a simlar problem here. After some investigation with a colleauge, we noticied that I had the Report option to 'Allow Users to Change Filter Types' selected on my desktop. When I unchecked this option, republished the report and updated the App, the filters were respected as they should be.
Very strange affect, but it worked for us :)
That seemed to solve about 80% of my problem, thank you! That option was already deselected in my report, but I toggled it on and off, and now most of my bookmarks are exporting as expected. There is only one bookmark that is still displaying the default view and values when exporting.
For context, this report is a single page with 6 buttons at the top. Each button is tied to a bookmark that essentially unhides a different table. The only difference between these tables is the dimension in the row context.
I have the same problem but with no bookmarks and the filter option unchecked.
Basically the export to PDF option ignores all filters.
I wish Microsoft would get their **bleep** together and fix issues to features they have already rolled out. Notice the decomposition tree they rolled out works great on the desktop and barely at all online.
After further research, it looks like this is affecting reports that use buttons linked to bookmarks to hide/unhide visuals. For example, some reports have multiple tables on a page, and a user uses the bookmark to select which table they'd like to see. Filters are respected on export before the user selects a button, but not after. Other reports are now exporting as expected.
Giorgi1989Advocate II
I wonder whether any fix has been found for this issue?
I am still encountering the same issues/concern. Are there any updates on this?
For me this doesn't work. I don't have bookmarks on this report, but it will only export to PDF with default data in stead of current.
The checkbox "allow users to change filter types" was already checked, so this doens't work either.
Same. Any updates or any suggestions for a workaround?
Hi all,
I encountered this issue this morning for one of my reports. The weird thing is the it only occurs for this specific report and only from today. It was working flawlessly before today. Logically, I enabled and disabled report options one by one and found that the 'persistent filter' was causing the issue. Once, I've disabled the option, the export to pdf worked. Hope this helps someone.
