Forum Discussion
Solved
Custom Power Query Code for refresh not to fail when there is no source data files
Hi Guys, Is the following possible to implement in Power Query? I am sourcing set of CSV files from a folder in Azure Blob Storage. Then I am combining these files in Power query before loadi...
Hi Mann
Then you add a last step to your queries that checks for existing errors and in case of error, produces an empty table. Usually it is necessary to have the column names still in place. You can hardcode such a table like so:
#table( {"ColName1, ColName2..."}, { { } } )
The step would look like so:
try <PreviousStepName> otherwise #table( {"ColName1, ColName2..."}, { { } } )
