Dataset in service not refreshing properly

Hi all, apologies I've not replied to anyone, I've been on vacation. 

I really don't want this thread to go dead, because it's still an issue for me.

An update on this is that I can refresh the dataset in PBI desktop and get the perfect results. I can then publish this to the service and those correct results are mirrored. Great! I then refresh the dataset in the service (after making no changes to the sources) and get the same, incorrect, results I've been getting for weeks. It's very frustrating.

My query essentially reads a table in an excel spreadsheet that is updated every week. It then determines which entries are existing, which are new, which have changed etc. I then have a custom column which states whether each row is to be 'deleted', 'updated' or 'created'. Power Automate then uses this column to determine whether it is to add, update or remove entries from a sharepoint list. Quite simple really. I just can't see why it's causing an issue in the service. It's like its holding old data instead of pulling the new data down, whereas the desktop version works as it should.

Thank you all