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 ...
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

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