Power query - stopping refresh if no data available

[Kariba]

Hi, I have a master workbook of data which I update three times a week with a rolling 30-day data file I receive.
The data is from 3 days ahead to 33 days ahead.
I then use power queries in multiple other workbooks to pull latest data over from that master file.
Column A is the date of latest update I received. Column B is the date of between 3 and 33 days ahead.
The power query then finds the latest info from column A and column B

However, we've just taken on someone new who unfortunately despite best efforts keeps refreshing data for days 1 & 2. As there is no data so no match for those days, the power query wipes out all existing data and then all the lookups, conditional formatting etc in the workbooks gets adjusted automatically.

I can't find any way to prevent a refresh if no data is found.

Anyone know how to do this if it's even possible?

Last update Start of data file

 

[Matt Allington]

Generically speaking, there is a “try….otherwise….” Pattern that may be helpful. If the try step throws an error, the otherwise step kicks in. Maybe you could create 2 queries with the first throwing an error if there is no data you need. Just an idea.

 

[Kariba]

Tried this and seems to work so far

If Range("C11").Value >= Date + 3 Then
Range("C11").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
Else
MsgBox "Not refreshed", vbCritical, "Warning"