Forum Discussion

Icon for Helper IV rank

Helper IV

6 years ago

Export to PowerPoint or PDF is not filtered properly

When I use the Export to PDF or PowerPoint, I select to use the current values -- but the report that generates is not filtered at all and looks like it's using no filter criteria. Is there a known p...

Icon for Helper IV rank

Helper IV

6 years ago

I found something interesting. If I have a filter applied via the URL query string (by adding ?filter= to the URL when navigating to the report in my browser), the export does not filter (even though the filter pane does show the filter applied and report works normally otherwise).

I really enjoy the URL filter, it helps me make this more seamless from users navigating to the report from other systems so they land on an already-filtered report view.

Icon for Community Support rank

Community Support

6 years ago

Like this? Your idea is very creative.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CmdrKeene
Helper IV
6 years ago
That's exactly right. Here's an actual example:
https://app.powerbi.com/groups/9792ecd3-7fcc-4301-bacb-8f137299f931/reports/28d24e47-10b3-4f5e-b6c9-1a2b01f175da/ReportSection57d97b324aa2baea2817?filter=Sites%2FTFID%20eq%20%2719442502%27

The %2F is a /
The %20 is a space character
The %27 is apostrophe (single quote mark) '

So the same URL can be written as:
https://app.powerbi.com/groups/9792ecd3-7fcc-4301-bacb-8f137299f931/reports/28d24e47-10b3-4f5e-b6c9-1a2b01f175da/ReportSection57d97b324aa2baea2817?filter=Sites/TFID eq '19442502'

Going to the URL does indeed filter the report correctly and all the visuals have that filter applied. But when I export out the PDF, the filter is not applied to the export.
- v-lionel-msft
  Community Support
  6 years ago
  Hi CmdrKeene ,
  
  This is true, so you need to manually change the filter selection in the filter pane on the right when you export to PDF. Because you will find that the URL link don't change when you change the filter selection.
  
  Or submit an idea .
  
  Best regards,
  Lionel Chen
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - CmdrKeene
    Helper IV
    6 years ago
    It seems like it must be a bug. Since the URL filters are officially supported, and they do apply the correct filter in the filter pane. But for some reason the export doesn't recognize that the filter is set.