how to resolve error 500 from external data source of a pivot table

Hello there,

Hope all is going well. I am extracting some data from a website into a pivot table using the external source method every 2 minutes. The data gets transferred just fine but when the table I am extracting the data from is empty (there is no data in the table); an error is thrown and I am shown this popup of error 500, screen shot attached. is there a way around this; if the table is empty, the error doesn't get thrown and it just refreshes again in 2 minutes. just keep on refreshing every 2min until data is there. thank you

regards,

SN