How to use variable path to open Excel files

[aleonc]

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!!

[v-frfei-msft · Accepted solution]

Hi @aleonc ,

Please refer to the third - party bolg the learn about Using Variables for File Locations.

[Greg_Deckler]

Use a query parameter.