load data into power BI from relative path
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
You can use also the "Parameters" function. 1. Create a new Parameter like "PathExcelFiles" Parameter_ScreenShot
- Edit your "Source" entry SourceEntry_ScreenShot
Done !