Forum Discussion
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 that I can tell PQ to ignore any websites that are down, and just complie from the working sources?
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({},{}),
2 Replies
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({},{}),Thank you!
