Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
furmangg
Frequent Visitor

URL parameter to filter report on a field with spaces

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?

10 REPLIES 10
EricShahi
Helper IV
Helper IV

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
Regular Visitor

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
Advocate I
Advocate I

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

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

StephenWagner
New Member

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.

Has anyone heard any news on a fix?

konstantinos
Memorable Member
Memorable Member

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;

 

Konstantinos Ioannou

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors