Forum Discussion
How to combine embedding-mode and url-filtering
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
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.