topic Re: URL Filtering not working in DAX Commands and Tips

URL Filtering not working

Kushagra — Fri, 03 Mar 2023 14:58:08 GMT

Hi I have tried filtering powerbi report using url filters, but unable to make it filter the published report

{url of report}/ReportSection?filter='Sheet1'/name eq 'Samuel Jack'

Any help is appreaciated. Thanks in advance

Re: URL Filtering not working

OwenAuger — Sat, 04 Mar 2023 11:05:56 GMT

Hi Kushagra

A couple of suggestions that may help:

Does your table Sheet1 contain the column Sheet1[name]?
Just checking, since the column used in the visual appears to be name column.
If it doesn't exist, you could create a name column and set it equal to name column.
Column names used in URL parameter filters only work if they don't contain spaces.
In my testing, filters will not work if table names are enclosed in single quotes, so remove the single quotes around Sheet1.

Putting this together, as long as your table Sheet1 contains the column name, this should work:

{url of report}/ReportSection?filter=Sheet1/name eq 'Samuel Jack'

Re: URL Filtering not working

Kushagra — Mon, 06 Mar 2023 06:32:04 GMT

Hi Owen,

I tried using a new report, with correct names of table and columns, but it still wont work. Is this a limitation of PowerBI Pro license for a report that is published?

How my data looks has been shared below for reference -

Visualization view -

Dataset -

After publishing, my url to test this filtering is - {url of the report}/ReportSection?filter=Salary/emp eq 'Jack'

Yet there is no update on the filter (both with and without filter lock on PowerBI desktop)

Re: URL Filtering not working

OwenAuger — Tue, 07 Mar 2023 11:57:23 GMT

Hi again Kushagra

That's odd that it's not working at your end. Have you had any success since your last message?

I have created and published a report essentially identical that in your last post, and the URL filter you posted works as intended. I used an account without a Pro licence and published to My Workspace.

Regards,

Owen

Re: URL Filtering not working

Anonymous — Thu, 08 Feb 2024 20:34:38 GMT

I am trying to use a URL for Employee Name. Does the limitation for filtering on a URL still have to be a single name without spaces? Or, does anyone have other suggestions to work around this? We have a page with multiple reports/visuals, all relating to the Employee. I'm trying to see if I give the URL to this page, but then just with a specific Employee Name, how to do this.

Thank you for any suggestions.

Re: URL Filtering not working

OwenAuger — Thu, 08 Feb 2024 21:25:38 GMT

Hi Anonymous

Yes spaces are allowed in the URL filter parameter.

For example, I published the attached PBIX and this form of URL filters the report correctly:

https://app.powerbi.com/groups/me/reports/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/ReportSection?filter=Employee/Name eq 'Will Graham'

The spaces and other punctuation marks within the parameter will be converted with percent-encoding (%20 etc) and can also be entered that way in the first place.

Regards

Re: URL Filtering not working

Janey2024 — Thu, 27 Jun 2024 04:21:10 GMT

What if in my case, the column names contains space, is there a way to make this work by url filter?

Re: URL Filtering not working

OwenAuger — Thu, 27 Jun 2024 11:42:22 GMT

Hi Janey2024

Yes, see here.

If table or column names contain spaces, they can be encoded as

_x0020_

I just tested this with one of my own reports and it's working as expected 🙂

For example, to apply a filter equivalent to this DAX expression

'Employee Table'[Employee Name] = "Jack"

a valid report URL would be

https://app.powerbi.com/groups/me/reports/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/ReportSection?filter=Employee_x0020_Table/Employee_x0020_Name eq 'Jack'

Other special characters can be encoded similarly with 0020 being replaced by the 4-digit Unicode hex code of the character.

Regards