URL query string parameters on multiple table and fields

[Anonymous]

Hi,

Is it possible to filter the report using url query string parameters on multiple tables.

When I try to filter the report in the below format , it is just filtering with first 3 filters.

Report url?filter=table1/field1 eq ‘value’ and table1/field2 eq ‘value’ and table2/field1 eq ‘value’ and table2/field2 eq ‘value’

Many Thanks,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, the URL query string parameters can filter more than 3 filters on my side, we tested with the following format:

https://ReportURL?filter=Budget/Brand eq 'Litware' and Budget/CountryRegion eq 'United States' and Sales_x0020_2015/Month eq 'April' and Sales_x0020_2015/Sale_x0020_2014 eq 172.00

 

Based on this document, Report URL filters have a 10-expression limit (10 filters connected by AND). Special characters and spaces require some additional formatting.  please refer to this document about the additional format: https://docs.microsoft.com/en-us/power-bi/service-url-filters#special-characters-in-url-filters

Best regards,