Forum Discussion
PowerQuery if null then Skip
Hi all, I want to call an API but if returns nothing the Expanded Column1 give me an error. If there a way to skip it? let
Source = Json.Document(Web.Contents("https://api.site.com/ap...
efilipe you can use try otherwise, check these posts:
https://docs.microsoft.com/en-us/power-query/handlingerrors
https://blog.gbrueckl.at/2013/12/error-handling-in-power-query/
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!