Forum Discussion
Export report with multiple filters as parameter
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)"
}]
}
}
Did you try using the same filter string for both filtering the 2 fields as explained here:
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.
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
3 Replies
Did you try using the same filter string for both filtering the 2 fields as explained here:
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.
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
That is correct - it is a current limitation. Try using page level bookmarks instead.
