Export report with multiple filters as parameter

[Anonymous]

I am looking for a way to export report to file in image/pdf format with multiple filters applied as parameter using rest API. When accoring to https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile#code-try-0 when the body is as follows, am getting error message as "Export report with more than one filter is not supported".

{
 format: "pdf",
 powerBIReportConfiguration:{
  reportLevelFilters:[{
   filter:"LOCAL/PS_SGMNT_VAL in ('MPC')"
  },{
   filter:"LOCAL/SYS_ID in (605)"
  }]
 }
}

[AmosHersch · Accepted solution]

Did you try using the same filter string for both filtering the 2 fields as explained here:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#filter-on-multiple-f...

Basically you should probably test your filter string first by adding it to the report URL in PowerBI service, and if it works there it should also work in the API.

[v-shex-msft · Accepted solution]

Hi @Anonymous,

AFAIK, current it does not support usage your sample shared. Please concatenate these filters into the URL string as the url filter document mentions.

Reports - Export To File#exportfilter 

Filter a report using query string parameters in the URL 

Regards,

Xiaoxin Sheng

[AmosHersch · Accepted solution]

Did you try using the same filter string for both filtering the 2 fields as explained here:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#filter-on-multiple-f...

Basically you should probably test your filter string first by adding it to the report URL in PowerBI service, and if it works there it should also work in the API.

[lbendlin]

That is correct - it is a current limitation.  Try using page level bookmarks instead.