cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cini_Varghese
Frequent Visitor

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)"
  }]
 }
}
2 ACCEPTED SOLUTIONS
AmosHersch
Microsoft
Microsoft

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.

View solution in original post

v-shex-msft
Community Support
Community Support

Hi @Cini_Varghese,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Cini_Varghese,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

AmosHersch
Microsoft
Microsoft

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.

View solution in original post

lbendlin
Super User
Super User

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors