Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello World!
I have a special character in my field name that is causing an error in my load. This field is referenced in a field select function.
fieldselect = "&$top=5000&$select= Author/Title, ASM/Supervisor/Title, Editor/Title, AssignedTo/Title&$expand=Author,Editor,AssignedTo"
The name of the field is "ASM/Supervisor". Does anyone know of a solution to escape this special character within field select?
Thanks in advance.
This looks like OData. I think you just use ASCII escaping, so / is %2F.
fieldselect = "&$top=5000&$select=Author%2FTitle, ASM%2FSupervisor%2FTitle, Editor%2FTitle, AssignedTo%2FTitle&$expand=Author,Editor,AssignedTo"
This page is a good reference for other special characters: HTML URL Encoding Reference (w3schools.com)
Hi @Anonymous ,
Based on the description, not certain where did you use it in a 'field select function', and what's the error message it shows.
Maybe you can share more details like the error message and the query you have quoted this field for further discussion.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Not clear if you need to remove special characters from the whole text, if so in Power Query, add the following as new custom column
= Text.Select([Your Field Name],{"a".."z","A".."Z","0".."9"," "})
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
No need to remove. I have a "/" in my field name "ASM/Supervisor" that, when refernced in fieldselect, brings back an error. I need to escape this special character so that the field name is readable.
@Anonymous
Did not understand what is "fieldselect" here. Can you explain a bit not more? Is it power query ?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |