How to combine embedding-mode and url-filtering

[MagicMads]

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?

[v-yulgu-msft]

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

[Anonymous]

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!

[cjames76]

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

[gess6321]

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

[d_gosbell]

---

@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.

[Jon-Heide]

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