topic Re: URL Filtering Issue in Report Server

URL Filtering Issue

Nixan — Mon, 01 Jul 2024 12:38:09 GMT

I have an issue with URL filtering my page level filter is 'Projects'[Project Name] . When trying to filter using

would not work.

lbendlin — Mon, 01 Jul 2024 18:50:58 GMT

Don't include single quotes or square brackets for table and column names.

Nixan — Mon, 01 Jul 2024 22:54:12 GMT

I tried that but it's not working. Is there anything else I can try.

Anonymous — Mon, 08 Jul 2024 02:35:21 GMT

Your ideas is so great lbendlin

You can use the following link to put the data in your report where the Project name column of the project table equals Accela GIS.

As provided by Super User. Since there is a space in your column Project name, we need to use the escape characters provided by the document.

%20

Let's take the example PBIX file for Power BI as an example. An example URL for filtering Store Type = New Store is:

https://app.powerbi.com/groups/xxxx/reports/xxx/ReportSection4?filter=Store/Store%20Type eq 'New Store'

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.