Skip to main content
Microsoft Idea

Power BI

Completed

Add filter options to the 'Export File' API

Vote (85) 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 06 Mar 2022 17:19:21

It's done

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

Power BI Ideas Admin 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

Lloyd Williams 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.