topic How to combine embedding-mode and url-filtering in Report Server

How to combine embedding-mode and url-filtering

MagicMads — Fri, 17 Nov 2017 14:28:44 GMT

Hi - it is possible to change Power BI Report Server rendering by adding ?rs:embed=true - it is also possible to add a ur-filter by adding ?filter=Table/Column eq 'Value' - but how do you combine those?

Re: How to combine embedding-mode and url-filtering

Jon-Heide — Sat, 18 Nov 2017 00:54:37 GMT

Yes, you can combine both on the URL. You might need to add a delimiter between them (for example ";" )

Re: How to combine embedding-mode and url-filtering

v-yulgu-msft — Mon, 20 Nov 2017 02:33:37 GMT

Hi MagicMads,

Here is an article for your reference: Quickstart: Embed a Power BI report using an iFrame and URL parameters

Best regards,

Yuliana Gu

Re: How to combine embedding-mode and url-filtering

Anonymous — Fri, 07 Feb 2020 21:11:26 GMT

This doesn't address the question. The auther was looking for a way to alter the URL of his report so that it opens in full scren move (by adding ?rs:embed=true) as well as filter his report (by adding ?filter table/column eq 'value').

I haven't found a way to combine these that works, but it would be incredibly useful if you could! Any help would be greatly appreciated!

Re: How to combine embedding-mode and url-filtering

cjames76 — Sat, 08 Feb 2020 11:39:42 GMT

Hi,

The following format worked for me on a report I published earier this week...

?rs:embed=true&filter=table/column eq 'filtervalue'

I initially had some issues geting it to work as I had spaces in the name of the table that I wanted to filter, after I replaced them with underscorces it worked fine.

Hope this helps

Re: How to combine embedding-mode and url-filtering

d_gosbell — Mon, 10 Feb 2020 02:58:53 GMT

cjames76 wrote:

Hi,

The following format worked for me on a report I published earier this week...

?rs:embed=true&filter=table/column eq 'filtervalue'

Yes, that is the correct format to use. When you pass query string parameters like this you need a ? delimiter between the address of the report and the first parameter, but then you use & between each subsequent parameter.

So both

?rs:embed=true&filter=table/column eq 'filtervalue'

and

?filter=table/column eq 'filtervalue'&rs:embed=true

should work the same.

I initially had some issues geting it to work as I had spaces in the name of the table that I wanted to filter, after I replaced them with underscorces it worked fine.

If you look at the section here on special characters in URL filters it explains that spaces need to be replaces with _0020_ so something that would be 'table name'[column name] in DAX would become table_0020_name/column_0020_name in a URL filter.

Re: How to combine embedding-mode and url-filtering

gess6321 — Thu, 17 Jun 2021 21:30:06 GMT

how did you get it to work? I keep coming up with a blank page