Tables not getting updated in the data model

[rohanjha1988]

Hi All,

I have a source file in which there are multiple tables such as CustomerMaster, SalesMaster etc. Now this source file is getting updated every day and the name of the source excel file is also getting updated like MasterSheet_06.07.2020. This source file is an excel file. 

The first model was created on the file named - MasterSheet_01.07.2020. Now if i open the file MasterSheet_06.07.2020 then i can see the data model but when i am refreshing the queries then some tables like CustomerMaster is getting updated but getting an error "We couldn’t refresh the connection. Please go to existing connections and verify they connect to the file or server." while updating the SalesMaster file. When i checked in the existing connection tab then i cannot find any connection. When there is no existing connection then how come some tables are getting updated but some are not? 

Please help!!!

[amitchandak]

@rohanjha1988 , you are handing the name change in Power Query. As long as the file sources are correct it should update. If you two files and one path is correct, it will update one.