Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! i'm having a problem with a connection, when i try connect with an API, the return a DataFormat.Error, this error is caused because have a value using a invalid character "\'" and i can't remove this one. Is there a way to change this?
Thank you for help!
likely you ae making the Web.Contents call and the JSON.Document step at the same time. Separate these steps.
Show your sanitized Power Query code.
Hello! yes, i have a sample.
so it's not the backslash that's the issue - it's the escaped single quote. Since your "observation" string uses double quotes this single quote escape is not necessary. Either change the setting in the source (to not escape single quotes) or add a process step to replace "\'" with "'".
understand! But in this case i can't change the setting in the source and it is not possible add a process to replace this character.
So i need another way to input this information!
and it is not possible add a process to replace this character.
Why not? That can be done in Power Query.
Because, when i make the connection it's return me an error.
Please show a sample of the return payload.