Hello all

in folder named "D:\Jan" i have excel file named "Source.xlsx" which is contains about 10 tables
in the same folder i have file named "Pivots.xlsx" which contains data model from the source file,

each month i create a copy of that folder and rename it with the Month name like "D:\Feb" then edit data and data model connections to connect to the data file that in the same folder "Feb"

is there is a way to change Data Model location for multiple tables at once in stead of changing it one by one ???