Forum Discussion
Solved
Ignore Data source if fails to load
I have a Query that pulls from about 24 different websites, and then compiles them. Occasionally, one of the websites will be down, which causes the entire file to fail to refresh. Is there a way t...
You may be interested in my answer to a related question here:
https://community.powerbi.com/t5/Power-Query/Append-all-queries-that-have-no-error/m-p/2868403The key is using try ... otherwise with an empty table fallback:
try #"Website Query 1" otherwise #table({},{}),
You may be interested in my answer to a related question here:
https://community.powerbi.com/t5/Power-Query/Append-all-queries-that-have-no-error/m-p/2868403
The key is using try ... otherwise with an empty table fallback:
try #"Website Query 1" otherwise #table({},{}),
Thank you!
