Forum Discussion

MarkPHarris1's avatar
MarkPHarris1
Helper I
6 years ago
Solved

URL Filtering when spaces in tablename

Hi there,

 

I was wondering if you can help, I am encountering a error when trying to do url filtering from one powerbi report to another, the problem being the tablename has a space in it. Here's my dax so far:

 

"report URL - ReportSection?filter=fact facttable/Project eq '" & MAX('fact facttable '[Project]) & "'"
 
This doesn't work, it takes me to a webpage but the fitering doesn't work, and I think it is caused by the "fact facttable" having a space in it. Is there anyway in the url of escaping the space in the tablename? There is no way for me to change the name of the table incase you are wondering(I'm using a powerbi dataset which is used by a large number of our staff, so can't just be changed for me).
 
Thanks for your help,
 
Mark
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  MarkPHarris1 

    Just use "_x0020_" instead of space in the table name, like this:

    ReportSection?filter=fact_x0020_facttable/Project eq '" & MAX('fact facttable '[Project]) & "'"

     

    https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters

     

    Special characters in URL filters

    Special characters in table and column names

    Special characters and spaces in table and column names require some additional formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. Here are some examples.

    Identifier Unicode Coding for Power BI
    Table Name Space is 0x20 Table_x0020_Name
    Column@Number @ is 0x40 Column_x0040_Number
    [Column] [ is 0x005B ] is 0x005D x005B_Column_x005D
    Column+Plus + is 0x2B Column_x002B_Plus

     

     

    Regards,

    Lin

5 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  MarkPHarris1 

    Just use "_x0020_" instead of space in the table name, like this:

    ReportSection?filter=fact_x0020_facttable/Project eq '" & MAX('fact facttable '[Project]) & "'"

     

    https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters

     

    Special characters in URL filters

    Special characters in table and column names

    Special characters and spaces in table and column names require some additional formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. Here are some examples.

    Identifier Unicode Coding for Power BI
    Table Name Space is 0x20 Table_x0020_Name
    Column@Number @ is 0x40 Column_x0040_Number
    [Column] [ is 0x005B ] is 0x005D x005B_Column_x005D
    Column+Plus + is 0x2B Column_x002B_Plus

     

     

    Regards,

    Lin

    • MarkPHarris1's avatar
      MarkPHarris1
      Helper I
      6 years ago

      Hi Lin,

       

      Thanks for all the additional info, that fixed it!

       

      BW 

       

      Mark

  • EricShahi's avatar
    EricShahi
    Helper IV
    3 years ago

    v-lili6-msft  amitchandak MarkPHarris1 


    Table Name  = Department (measure)

     

    Filter = Team is "Accounting" 

     

    Adding below to my URL Code : 

     

    ?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'

     

    This is not working for me ??

    • akhilsali3's avatar
      akhilsali3
      Regular Visitor
      1 year ago

      missed courple underscore there - try this - ?filter=Department_x0020__x0028_measures_x0029_/Team eq 'Accounting'