Forum Discussion
Report Custom URL Filter not working
After more trial and error, I have discovered that Undescores are not supported in either table or column names. Also it seems the value has to be quoted. Single quotes work, which convert to %27 in the URL.
Step 1 in the doco is misleading. Ignore it.
Also my thought that the column may already need to exist in either page or report filters was unfounded. The URL filters work without this.
Unfortunately, if you construct the custom URL, and then try to use it as the URL for a dashboard tile, the service ignores the filter part. This is very annoying, and relates to other ideas posts asking for tiles created from filtered or sliced reports to reinstate the filter or slices when you click through from the tile to the report. So no viable workaround for that annoying behaviuor yet.
After more trial and error, I have discovered that Undescores are not supported in either table or column names. Also it seems the value has to be quoted. Single quotes work, which convert to %27 in the URL.
Step 1 in the doco is misleading. Ignore it.
Also my thought that the column may already need to exist in either page or report filters was unfounded. The URL filters work without this.
Unfortunately, if you construct the custom URL, and then try to use it as the URL for a dashboard tile, the service ignores the filter part. This is very annoying, and relates to other ideas posts asking for tiles created from filtered or sliced reports to reinstate the filter or slices when you click through from the tile to the report. So no viable workaround for that annoying behaviuor yet.
Hi,
has someone tried url filtering with power bi hosted on premise on SSRS 2016?
Best Regards,
Daniel Serafimovik
