Error Handling for Data Source

[deevs]

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,

[mwegener · Accepted solution]

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.

[deevs]

HI @mwegener .

Really appreciate your help on this