The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |