Filtering reports using query parameters in the URL

When you open a Power BI report, each report page has its own unique URL. To filter that report page, you can use the "Filters" panel on the report screen. Another option is to add query parameters to the URL to filter the report. Perhaps you have a report that you would like to show to colleagues, but first you want to filter it before sending it to them. One way to filter this is to start with the report's default URL and add filter parameters to the URL.

Just as the Power BI service supports URL parâmetros de URL para filtrar os dados, Power Embedded now also supports the same parameters for filtering report data.

Syntax of query string parameters for filtering

Report URL?filter=Tabela/Coluna eq 'valor'

Exemplo: https://relatorios.powerembedded.com.br/Organization/12201800-1a46-491a-bfe3-6ee5590e372e/Report/a0397cac-3ced-40e0-a1b4-6011518391c2?filter=Participantes/email eq '[email protected]'

To see more information about the types of filters supported, how to filter using multiple values and multiple fields, go to the page Filtrar relatórios usando parâmetros da cadeia de caracteres de consulta na URL.

Observações

• Table and Field names are case-sensitive, value names are not;

• Fileds hidden in the report display can still be filtered.

• For this feature to work, the column, that will be used to filter the data must be available in the report´s filter side painel.