load data into power BI from relative path

Question

I am trying to find a solution to load an external data file but from a relative path, so when someone else open my PBIX it will still work on his/her computer.

many thanks.

Answer 1

Relative paths are *not* currently supported by Power BI.

---

To ease the pain, you can create a variable that contains the path where the files are located, and use that variable to determine the path of each table. That way, you only have to change a single place (that variable) and all the tables will automatically point to the new location.

Create a Blank Query, give it a name (e.g. dataFolderPath) and type in the path where your files are (e.g. C:\Users\augustoproiete\Desktop)

With the variable created, edit each of your tables in the Advanced Editor and concatenate your variable with the name of the file.

e.g. instead of "C:\Users\augustoproiete\Desktop\data.xlsx", change it to dataFolderPath & "\data.xlsx"

---

You can also vote/watch this feature request to be notified when it gets implemented:

• Support relative path to excel/csv sources

Answer 2

You can use also the "Parameters" function. 1. Create a new Parameter like "PathExcelFiles" Parameter_ScreenShot

2. Edit your "Source" entry SourceEntry_ScreenShot

Done !