Error Handling for API calls - Authentication issue

[OndrejH]

Hello,

We are using Custom Connector to retrieve data from client API. When using OAuth Authentication how can we handle error responses e.g. "user has no access" or easy as "Data not Found", "Resource not found" 404 error.. all of this within a simple solution e.g. if response state code 404 throw an errror. Could you please point to right direction or give some examples regarding the Authentication error handling issue?

Thank you

[v-jingzhang · Accepted solution]

Hi @OndrejH 

These blogs and videos may be helpful.

Chris Webb's BI Blog: Handling 404–Not Found Errors With Web.Contents() In Power Query And Power BI ...

Handling HTTP Errors in Power Query and Power BI • My Online Training Hub

Handling HTTP Errors in Power Query and Power BI - YouTube

Official docs:

Handling status codes with Web.Contents for Power Query connectors | Microsoft Docs

Error handling for Power Query connectors | Microsoft Docs

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.