Skip to main content

End-User Filtered Export capabilities now available

For the third straight week, we’re delivering on the item I’ve heard more end-user feedback around than any other we’d promised to deliver in the October blogpost.  At long last, you and your users will be able to export their Power BI reports to either PDF or PowerPoint and have their selections on the screen be respected in the exported document!  Please note this feature is still rolling out to all regions and should be available everywhere by Feb 17th.

Now, when you export to either PDF or PowerPoint, you’ll see the following pop-up window –

By default, you’ll be exporting the current report values, which is what you see on the screen along with any other changes you’ve made across the report during your session.  For your quick reference, if you’ve change any of the following for the current report page, you’ll see it in your export –

  • Filters
  • Slicers, including slicer type (for example, dropdown or list) and slicer state
  • Visual selection state (such as cross-highlight filters)
  • Sort order
  • Drill location
  • Visibility (of an object, using the Selection pane)
  • The focus or Spotlight modes of any visible object

For pages in your report that you’re not viewing when you export your report, it’ll respect the same items respected with Persistent Filters, and those changes will also be shown in your exported report.

If you’d prefer NOT to have any of your changes in your exported document and continue to have it work as it did prior to today in the service, simply change the dropdown to “Default Values”, and it will export the report as it was originally authored.

An additional enhancement we’ve added is the ability to exclude any hidden report tabs from the exported report.  Until now, all the report tabs, including those the author had hidden, were included in the export.  This often times would unnecessarily increase the size of your export, and users asked to exclude those in certain cases.  Now, if your report has any hidden tabs, you may simply check the box to “Exclude hidden report tabs” and they won’t be included in your export.  If your report doesn’t have any hidden report tabs, the box will be grayed out and unavailable to select.

These last three weeks have been an exciting time for all of us on the Power BI team, and we’re thrilled to see users embracing the new capabilities as rapidly as they have.  We’re investing heavily in new managed distribution features throughout 2019, and you should look for many, many more enhancements announced here in the weeks and months to come.  Thanks for reading, and please let us know your feedback in the comments below!