Forum Discussion
Error Handling for Data Source
dear All,
Can anyone assist me with finding a way to handle the HTTP Error.
For an example when pulling data from a API , is there way to load an error message as a column to the table to avoid the data refresh being interrupted.
Thanks,
Hi deevs ,
Chris Webb wrote a blog post about it.
https://blog.crossjoin.co.uk/2014/09/18/handling-data-source-errors-in-power-query/
It first checks the source with M code and returns an alternative result in the expected data structure in the event of an error.
2 Replies
- mwegenerMost Valuable Professional
Hi deevs ,
Chris Webb wrote a blog post about it.
https://blog.crossjoin.co.uk/2014/09/18/handling-data-source-errors-in-power-query/
It first checks the source with M code and returns an alternative result in the expected data structure in the event of an error.
- deevsHelper III