Handling HTTP / API errors in Power Query | Return API errors instead of Power Query default ones

Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@sn3ider]

This is great! Thank you for sharing!

[@bboykaze9538]

I'll try this one !
Currently I use try function, it work very well but for some data it may slow down my report idk why
" try _myAPIcall_ otherwise _myAPIcallWhereImSureThereIsNoError_"
When doing this I'm sure that there will have no error due to error api response

[@bboykaze9538]

I use this function because all line have to call api endpoint filtering on cell's values. And then I expand the response

[@CurbalEN]

All apis are different, so it is impossible to find a solution that fits all. It is good to have all this tricks to try which one suits best!

[@loub7398]

What type of job do you do that you get to use these skills? Thank you

[@CurbalEN]

I am a Power BI consultant