PowerBI - Exporting reports to PDF or PowerPoint losing filtration on report.

[Kraken]

Morning,

It appears that something has changed within the functionality of the exporting within the PowerBI service area. 

Issue

Use the export as PowerPoint or PDF is removing any filtration the users have on the exported file. 

Expected

Whatever filters the user has applied on the page should be replicated within the exported file in either PowerPoint or PDF. 

Is this a known issue or a new feature?

Also, we are using the "Current Values" as the export option.

[mlong · Accepted solution]

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.

[jacschZA]

Interestingly this only seems to happen if there is a Bookmark created. If you remove the Bookmark from the report, it also then works.

Mentioned in the below old post.

But see the fix coming the 15th.
https://community.fabric.microsoft.com/t5/Desktop/Export-to-PDF-from-Service-not-respecting-Current-...

[we4get]

Hi all,

Just received this from MS - https://support.fabric.microsoft.com/en-SG/support/ 

Looks like fix planned for 15th 😀

[HackThemAll]

Same problem here, with some value the export to pdf function is working and with other not it seems a bug not an expected behaviour 

[DanNewton]

We are also having this issue in our environment and have opened a support request. @we4get have Microsoft aknowledged a bug/fault yet?

[we4get]

Hi @DanNewton 

I've been on calls with support team and demonstrated the issue (also referring to this thread originally noted by @Kraken )

Ticket is currently Open (Troubleshooting)

I've asked them if they can update in here (unsure if that's a normal request though 🙂 

[we4get]

I've raised a support ticket on this - 2309260050000376

[mlong]

The 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.

[DanNewton]

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.

[Kraken]

I 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?

[DanNewton]

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.

[LLong]

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

[we4get]

This is also impacting us. How do we get this picked up as a new issue?

Thanks

[pmreis]

Hi @Kraken 

After you select PDF or PPT + Embed an Image, you will see the prompt to specify if the export with Current or Default values. In order to keep the user selections please use "Current Values"

Did I answer your question? If so please mark my answer as a solution so that it can help others to find it!

[Kraken]

Sorry I didnt mention it. Yes they are using the current values option as they always have done.