Forum Discussion
aleonc
7 years agoNew Member
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!!
Hi aleonc ,
Please refer to the third - party bolg the learn about Using Variables for File Locations.
2 Replies
- Greg_DecklerCommunity Champion
Use a query parameter.
- v-frfei-msftCommunity Support
Hi aleonc ,
Please refer to the third - party bolg the learn about Using Variables for File Locations.