Forum Discussion
We found an invalid escape sequence in JSON input
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 remo...
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.