Forum Discussion

Kushagra's avatar
Kushagra
Frequent Visitor
3 years ago
Solved

URL Filtering not working

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 a...
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi Kushagra 

    A couple of suggestions that may help:

    1. 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. 
    2. Column names used in URL parameter filters only work if they don't contain spaces.
    3. 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'

     

     

Janey2024's avatar
Janey2024
Microsoft Employee
2 years ago

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

OwenAuger's avatar
OwenAuger
Super User
2 years ago

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