Excel power query with empty table

You can just wrap your last step in the query with try ... otherwise null.  

let

Source = ...

#"Change Type" = try ... otherwise null

in

#"Change Type"

Note that may cause errors downstream if that query is used in other queries, or if you have DAX calculated column(s).  If that is the case, you can make a query that has some mock data that matches the format of your real data.  In your Source step, you can use a Source = try Web.Contents(...) otherwise mockdataquery

That way all the downstream stuff will still work.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat