change folder source as I have moved the power bi file to different computer

[elatsusylex]

hello, so im encountering a problem, I'm a rather new power bi user, so when I first started and was receiving daily reports in excel files, I usually shove them into power per day, so now i have more than 30 files all coming from one folder. The problem now is that I want to change just the folder source as I have moved the power bi file to different computer is there any way to change just the folder source? Doing them one by one for each file is tedious

[Rayshin · Accepted solution]

@elatsusylex   You need to do transformation through power query, select excel table, go to advanced view and change the path and make sure to repeat for all excel tables.

[danextian]

Hi @elatsusylex ,

Changing the folder path is fairly simple for a few but  if you've connected to each file in the folder instead of the folder itself then you'll have to do it manually for each file as a data source.

In the Source step in the query editor, replace the path with the new one to update the source.