Forum Discussion

aleonc's avatar
aleonc
New Member
7 years ago
Solved

How to use variable path to open Excel files

Hi all! this is my first post, hope anyone can help me! Thanks in advance

I am using a Power BI board which read from differents excel files. Al these files are in a onedrive folder.

The problem is that every time I change the windows user or the Onedrive user, I have to change manually the path thats appear in the File.Contents function.

Any ideas? 

Thanks again!!