Skip to main content

Power BI

Planned

Add filter options to the 'Export File' API

Vote (54) Share
Power BI Ideas Admin's profile image

Power BI Ideas Admin on 31 Mar 2020 15:54:55

The 'Export to file' API endpoint is a great addition to the API, however, I was surprised to see that there is no way of passing in filter/slicer options.

Bookmarks can be applied, and are suggested as a workaround - but this isn't suitable for our use case.

We want to be able to generate PDF for sending out to multiple users - but need to set filters programatically - bookmarks wont let us do this.


Idea: Add Filter Options to the API Request Body - With capabilities similar to the JavaScript embedding API => (Filter Types, Operators, Values, and Conditions).

Thanks!

Administrator on 31 Jul 2020 10:16:40

It's part of the plan now

Comments (7)
Power BI Ideas Admin's profile image Profile Picture

de631e59 91d5-ea11-a813-000d3a9b112e on 08 Sep 2020 16:16:46

RE: Add filter options to the 'Export File' API

Can we get an ETA on GA for this feature?
We have stopped our Power BI adoption due to this limitation.

Power BI Ideas Admin's profile image Profile Picture

400a38f1 01d8-ea11-a813-000d3a579c34 on 06 Aug 2020 16:31:55

RE: Add filter options to the 'Export File' API

Really need this feature soon.
A must, must have for exporting automated PDFs and sending to my user groups.

Power BI Ideas Admin's profile image Profile Picture

ee7effca d3b0-4f2c-8797-320e27602156 on 06 Jul 2020 00:15:05

RE: Add filter options to the 'Export File' API

This is a must have feature. The limitations around automated reporting must be improved.

Power BI Ideas Admin's profile image Profile Picture

d3f0a703 42d8-4636-bb3f-a9aeb7dcf601 on 06 Jul 2020 00:13:06

RE: Add filter options to the 'Export File' API

This is such a mind-numbingly obvious feature that I can't believe it wasn't a Day 1 feature. Here's hoping we get it very soon.

Power BI Ideas Admin's profile image Profile Picture

5948ae82 0bed-4090-a8cf-abd5efe7ce09 on 06 Jul 2020 00:11:00

RE: Add filter options to the 'Export File' API

Paginated reports have a mechanism for passing in filters, please add something similar for power bi reports.

Power BI Ideas Admin's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:11:00

RE: Add filter options to the 'Export File' API

Sensible suggestion. This would really enhance the offering with added functionality.

Power BI Ideas Admin's profile image Profile Picture

4b2fc1c1 39a6-49c0-b92b-613528954d7b on 06 Jul 2020 00:11:00

RE: Add filter options to the 'Export File' API

Agreed, please add the functionality of passing parameterised values through to the filters before export.