PBI Secure Embed - passing filters to url

[Anonymous]

Have a problem with passing a filter correctly to an embedded url.

This is he filter I would like my report page to be filtered:

&$filter=’Main Table’/’Sales Level’ eq 'AMERICAS'

When appending this to my report url, the page is opened but the filter is not applied.

Here is a full url. 

https://app.powerbi.com/reportEmbed?reportId=XXXXautoAuth=true &pageName=ReportSectione776ca6d6b28d8e363c4&$filter=’Main Table’/’Sales Level’ eq 'AMERICA'

[v-lid-msft]

Hi @Anonymous ,

Sorry for our delay in response, Based on this document, we do not need to add $ in the filter, we can try to use the following url parameter which replace the space with special character:

https://app.powerbi.com/reportEmbed?reportId=XXXXautoAuth=true &pageName=ReportSectione776ca6d6b28d8e363c4&filter=Main_x0020_Table/Sales_x0040_Level eq 'AMERICA'

Best regards,

[Anonymous]

Thanks,

With small correction:

https://app.powerbi.com/reportEmbed?reportId=XXXX&autoAuth=true%20&pageName=ReportSectione776ca6d6b28d8e363c4&filter=Main_x0020_Table/Sales_x0020_Level%20eq%20'AMERICA'

The filter is passed to the right page and the visualisations are filtered. Unfortunatelly it is not passed to the slicer.

Slicer shows 'All' instead of 'AMERICA' and this may be very confusing to users

[v-lid-msft]

Hi @Anonymous ,

It is a by-design behaviour of the url parameter filter feature, it acted like a report-level filter, currently we cannot change the selected value in slicer by using filter parameter in url, we can only put a bookmark in button to clear the filter, and then it will show all the values in slicer.

Best regards,