Forum Discussion

EricShahi's avatar
EricShahi
Helper IV
3 years ago

Power BI URL query string parameters in the URL not working

Target Table Name = Department (measures) 
Target Column Name = Team 
Filter = Accounting 

URL + ?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'

As you can see above the " " is replace by unicode _x0020_  
the open bracket "(" by _x0028_
and lastly the closed bracket ")" by _x0029_

This URL filer is not hitting the filter for some reason ?
can't seems to find much on here either : https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-table-and-column-names

 

Need Help

4 Replies

  • EricShahi's avatar
    EricShahi
    Helper IV
    3 years ago

    if my table name is "Department measure" then below URL works 

    URL + ?filter=Department_x0020_measure/Team eq 'Accounting'

     but if my table name is "Department (measure) the below url doesn't work on browser and doesn't target right table/collumn with filter

    URL + ?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'


    GilbertQ 
     

    • GilbertQ's avatar
      GilbertQ
      Super User
      3 years ago

      To me that appears to be a limitation in the URL filter. I would try and change it to a name without the round brackets.

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi EricShahi 

     

    What happens if you try this just using it in the URL in the browser does it work with the above code?

     

    I would suggest trying that until you can get it working there and then apply it to your code?