Press "Enter" to skip to content

Returning an Empty Table in Power Query

Imke Feldmann doesn’t want you to leave empty-handed:

When your query returns an error, sometimes it could make sense to return an empty table instead of a simple error message. And ideally, this table has the same columns and types than the table that would have been returned without the error. Check out Chris Webbs article about it here: Chris Webb’s BI Blog: Handling Data Source Errors In Power Query Chris Webb’s BI Blog (

Read on for a function which generates an empty replica table based on some other table.