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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
msgeorgie
Regular Visitor

Parameter URL with space in Column Name

I am having a problem passing parameters to a url when the Column name has a space in it.  But when there is no space in the column name there is no issue.  Please advise ?filter=Tablename/Column name eq 'Passed Value' is the format I am using

Variables

Tablename = RDash

Column1 = Vendor

Column2 = Vendor Name

?filter=RDash/Vendor eq 'My Company' this works

?filter=RDash/Vendor Name eq 'My Company' this doesn't works

 

TIA

 

Any advice?  Do I need to rename my columns and possibly other tables to remove the spaces for this to work?

 

 

1 ACCEPTED SOLUTION
blopez11
Resident Rockstar
Resident Rockstar

2 REPLIES 2
blopez11
Resident Rockstar
Resident Rockstar

Try changing "Vendor Name" to Vendor_x0020_Name

 

The following reference may help:

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

Greg_Deckler
Super User
Super User

@msgeorgie Maybe try:

?filter=RDash/Vendor%20Name eq 'My Company' 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors