How to set page level filters during report export?

[Anonymous]

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?

[Anonymous]

@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.

[lbendlin]

same structure as this

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

ODATA filter format, escaping special characters.

[Anonymous]

@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?