Extracting Table for web -Between date Ranges - Error

I am not sure which date range between dates has a table ending with 100. is there any solution to check-in power query.

In short, no.  Power Query has no idea about the underlying logic of your data source.  It is your responsibility as a developer to implement code that adheres to the logic.

Alternatively you could extend the scope of the request (for example by not specifying a date range) and then do the filterning further downstream in Power Query.