Forum Discussion
How to set page level filters during report export?
We are using POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/ExportTo to export report page. According documentation it is possible to use reportLevelFilters field to set report level filters and page level filters are not working there.
Example request body:
{
format: 'PDF',
powerBIReportConfiguration: {
pages: [
pageName: '<page name>'
],
reportLevelFilters: [
filter: '<report level filter>'
]
}
}
How we can set page level filters?
4 Replies
- lbendlin
Super User
same structure as this
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
ODATA filter format, escaping special characters.
lbendlin Yes it is working, but is not possible to override report default filter values. If some default filter value (report or page level) is set it is possible to override it during report displaying (for example in React app). How it is possible to override default filter during REST API export or maybe such funcitonality plan to be added later?
lbendlin Thank you. Yes, it works. But how it is possible to override or ignore default filters?
1. Report has filter for field field_a with default value = 'value 1'.
2. We are calling https://api.powerbi.com/v1.0/myorg/reports/%7BreportId%7D/ExportTo with powerBIReportConfiguration.filter = ["field_a eq 'value 2'"].
Expected behaviour
Filter by value 2 applied.
Actual behaviour
Filter by value 1 and by level 2 applied.
- lbendlin
that's not the right format. You need to specify the table name too.
