I have been trying to filter my embedded PBI report using the filter query syntax:
&$filter={tableName/fieldName} eq '{fieldValue}'
and this works for me. However, when I apply more than one filter, the PBI report is filtered only according to the last $filter and other filters are disregarded.
Is there a way to add multiple filters in the Power BI embed URL?
With the release of 2.0.0 you can now get and set filters at report scope and page scope. We currently don't support visual scope but it is planned to come in the future.
See: https://learn.microsoft.com/en-us/javascript/api/overview/powerbi/control-report-filters for more information on how to use the SDK to apply filters.
You can also set filters during load.
https://learn.microsoft.com/en-us/javascript/api/overview/powerbi/configure-report-settings
You can see a working demo of using filters here:
https://github.com/microsoft/PowerBI-JavaScript/blob/master/demo/filters.html
If the filters you are applying need to be secure (they can't be modified by the client) then you must use RLS on the report, and then add the username and/or role claims to your JWT token. Then requests to view the report with this token will only show data for allowed user or role.
The OData $filter parameter only supports a subset of filter capabilities. If you want to have more complex values or conditions it is recommended to use the SDK to construct filter objects.
