URL parameter to filter report on a field with spaces

[furmangg]

Jumping off from this example:

http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically

I can successfully get this filter URL parameter to work:

https://app.powerbi.com/groups/<group guid>/reports/<report guid>/ReportSection1?filter=Date/Date eq...

That works fine because my table is named Date and my field is named Date.

If I try to filter on a field or a table with a space, then it fails:

?filter=My Table/My Field eq '2014'

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?

[EricShahi]

what do you in below situation when ,

Table Name = "Team (department)"

Is this correct way of doing is ? 

filter=Team_x0020_(department)/Team eq 'IT'

[harikv]

In case people still end up here looking for an answer, this is explained in the MS Documentation: 

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

[FGutiyama]

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

[RichieRich]

Thank you, that's a great tip. Worked in the Power BI export function in Power Automate too

[StephenWagner]

Is there a way to filter the "Publish to web" URL?  I've tried adding &filter=Table1/ZipKey eq '00001' but it doesn't work on this URL:

https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM...

but it does work on

https://app.powerbi.com/groups/me/reports/8d3cbf1e-3d89-46d3-ac1a-b24d0784b125/ReportSection?filter=... eq '00001'

I need to embed this report within a webpage.

[OneWithQuestion]

Has anyone heard any news on a fix?

[konstantinos]

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;

[furmangg]

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

[MattAllington]

Try using %20 instead of the single space character. I believe these are substitutes in URLs. 

[Anonymous]

Hello,

I have a situation where I need to send the filter values from Power BI report published on Power BI service to report builder as parameter values through URL. Do you have any idea on this? If yes, could you please help me out.