Gateway to connect an app to different local files paths

[Chrisjr]

Hello All, 

Here is my problem. 

I have at the moment one dataset on my workspace which is connected to an Excel file on my local machine. The path to the excel file is : C:\Users\Chris\Drive\File\Excelfile  

We do not use Onedrive / Sharepoint.  

Now, I would like PBI service to be able to use anotther path when my computer is off, meaning using path  of the Excel file wich is on a collegue's laptop. The path is howerver different for each collegues. For example, his path would be : C:\Users\Max\Drive\File\Excelfile

I have tried a cluster gateway but it didnt work. I guess the  path is the issue. 

Is there a way to solve this kind of scenario? 

Thank you

[Chrisjr]

Hi @Martin_D , 

Thanks for your reply.

I will try and let you know.

[Martin_D]

Hi @Chrisjr 
If the problem is just the different path, then you could substituate the indivudual path on each machine with the same virtual drive letter on both machines, as decribed, e.g., here: https://superuser.com/questions/29072/how-to-make-subst-mapping-persistent-across-reboots 

On one machine you would map  C:\Users\Chris\Drive\File to, e.g., Z: on the other machine you would map C:\Users\Max\Drive\File to Z: and in Power BI you would load the file from Z:\Excelfile

But I'm not sure whether the refresh will accept loading from different computers. Let me know once you tried.

BR

Martin