Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
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({},{}),
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!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
9 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |