URL parameter to filter report on a field with spaces

Question

Jumping off from this example:http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically&nbsp;I can successfully get this filter URL parameter to work:https://app.powerbi.com/groups/&lt;group guid&gt;/reports/&lt;report guid&gt;/ReportSection1?filter=Date/Date eq '31-Dec-2014'&nbsp;That works fine because my table is named Date and my field is named Date.&nbsp;If I try to filter on a field or a table with a space, then it fails:?filter=My Table/My Field eq '2014'&nbsp;Renaming table names and field names to remove spaces is not feasible as it breaks existing reports and makes the model less user friendly/readable. Is this truly a limitation in Power BI Service and there's no way to escape out the space?

fgutiyama · Answer

PowerBI leverages OData syntax, so try to replace the space by _x0020_ That worked for me.

konstantinos · Answer

There is a limitation - table or field names cannot have spaces , at least according to the post..

There must not be any dots in the filter parameters (datasource or parameter name) as the Power BI code rejects it silently as invalid names;

anonymous · Answer

I have reported this limitation here:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13852461-url-filter-report-field-that-has-a-space