How to change the data source in Power Bi without errors when refresh

Question

I have moved my data from a local file to Sharepoint, it is exactly the same just stored elsewhere.  I have also added the most recent data to that file but when refreshing in Power Bi desktop the visuals do not update and I get the error message of "Tbl_.... Load was cancelled by an error in loading a previosu table". This table is the original table when the data was stored locally (there are muliple err ors of this type listed).

 

Can anyone help, shjould I delete the originla tables in edit query first?

 

Many thanks

 

Andrew