Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 disab...
General Comment
Need Help
Show and Tell
  • AnkitKukreja's avatar
    AnkitKukreja
    4 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Would like to reply that a fix was deployed for my situation and report is exporting fine right now.

stayingdusty's avatar
stayingdusty
Frequent Visitor
4 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • stayingdusty's avatar
      stayingdusty
      Frequent Visitor
      4 years ago

      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:

      1. I go to a report via a URL that includes URL filters (i am aware that these do not work for export)
        1. Example: https://app.powerbi.com/groups/.../ReportSection?filter=Projects/Id eq 8
      2. The report loads correctly within PBI Online per the URL filter passed
      3. I manually select a filter option on a different field in the filters pane
      4. I export
        1. Result: The URL filters are not respected (this is expected) ✔️
        2. Result: The manually selected filter is not respected (this is a defect)

      The work-around:

      1. I go to the report with no URL filters
      2. I manually select a filter option in the filters pane
      3. I export
      4. 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.