Forum Discussion
Error on updating DataFlow
- 2 years ago
Thanks for answering Anonymous,
In fact, the problem was when converting text to JSON trying to convert a cell that was empty, then the error occurred.
Replacing the empty ones with [] or {} (depending on whether the column was an array or an object) and it worked.
Hi GustavoBorges ,
Please refer this document, hope it is helpful for you: Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- GustavoBorges2 years agoFrequent Visitor
Thanks for answering Anonymous,
In fact, the problem was when converting text to JSON trying to convert a cell that was empty, then the error occurred.
Replacing the empty ones with [] or {} (depending on whether the column was an array or an object) and it worked.