Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.