I have a Power Bi file that is linked to 10's of Excel files which are stored in the cloud and synced locally.
The file is edited by myself and a colleague. Everytime I open it I have to check the data sources are valid and if its been edited by my colleague relink all the Excel files which is time consuming and laborious. Of course once I save it and my collegaue then wants to edit it he has to go through the same proces.
Is there a way to either make the paths to the files relative rather than absolute if not is there a way to do a find and replace on the data source paths?