Forum Discussion

Mann's avatar
Mann
Resolver III
6 years ago
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...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    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..."}, { { } } )

     

Mann's avatar
Mann
Resolver III
6 years ago

Anonymous 

 

Thanks for your thoughts on this. 

Is it possible to do this technically in M query as I can't use Dataflows in current architecture.

 

If it is possible in M query can somebody give me some sample code to start with?

 

Mann.

 

<Looping some of Power Query experts who helped me learn through their impressive solutions in this community>

ImkeF 

MarcelBeug 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mann 

 

As I said the sample will vary depens on where you run your code. Is this Excel or Power BI Desktop?

 

Thanks,

JB