Forum Discussion
URL Filtering with number in table name
m4dt3o wrote:
Thank you d_gosbell, but this was the first thing i tried.
OK, but you did not mention that in your original post.
This does seem like a bug. I would suggest raising a support ticket for this so that an engineer can investigate this.
One work around that appears to work on the service is to encode the ASCII value for the leading number in the same way that the other special characters like spaces are encoded.
eg
?filter=1_x0020_table_x0020_name%2FColumn%20eq%20%27John%27
would become the following since 1 is ascii character 31
?filter=_x0031__x0020_table_x0020_name%2FColumn%20eq%20%27John%27
I do not think the issue is the number. It's most likely the space in the name. There are certain special characters which need special encoding and spaces are one of them (see Filter a report using query string parameters in the URL - Power BI | Microsoft Docs )
So instead of ?filter = 1 Sales/Name eq 'John'
It should be ?filter = 1_x0020_Sales/Name eq 'John'