Power BI

Needs Votes

Support relative path to excel/csv sources

Vote (1110)

Boris Lipschitz on 08 Sep 2015 10:25:40

Currently, when excel file is loaded to Power BI, the absolute filepath is captured in the M query. It would be nice if relative filepath was supported. Thus we could place excel file next to pbix and not worry about the file location (local machine, shared folder on server or onedrive)

Comments (85)

Comments (85)

Aaron E on 06 Jul 2020 00:07:27

RE: Support relative path to excel/csv sources

It's been over a year guys:

Bump this from the backlog to top of current sprint or top of the "Active Tasks" Kanban column, por favor.... It seems like everyone and their mother who writes scalable or deliverable code needs this.

Perhaps:
File.CurrentExecutionPath
File.CurrentPath
(Excel.CurrentPath would be too much trouble due to sharing)

Rick on 06 Jul 2020 00:06:38

RE: Support relative path to excel/csv sources

Please work on this. I am in an environment where I can not link to the source database and have to export all the info to Excel files before I can load them into Power BI. I am using Power BI to create daily reports and can not pass this on to the people that are actually responsible for those reports without constantly fixing data source locations or making sure that the user never moves a file once I fix the source location. Basically it cripples our use of Power BI.

Publishing is not an option because of strict IT policies. I would like to be able to just pass a folder to the user and tell them to just save over the appropriate Excel file with the new data. This way all the data and Power BI files are self contained in one folder.

Adil Yıldız on 06 Jul 2020 00:05:39

RE: Support relative path to excel/csv sources

This is absolutely needed and i believe it is a very core feature indeed. I really felt surprised when i learned Power BI did not support that.

Jeremy Faverjon on 06 Jul 2020 00:04:41

RE: Support relative path to excel/csv sources

I've been using this feature with Excel/Power query by creating a cell containing the current file location (basic excel formula). By including the file location in my query model, I was able to share the tool with my colleagues. They only had to update the data templates, save everything in one folder and they were able to run the tool without adjusting sources in query editor!

This would be a great feature that would enable us to create scalable visualization tools using only standard data templates. That would be simply AMAZING!

Peter Gunardi on 06 Jul 2020 00:03:50

RE: Support relative path to excel/csv sources

Hi, I need this feature. It will make my work scalable.

Stephen Paul Wright on 06 Jul 2020 00:02:53

RE: Support relative path to excel/csv sources

It would be useful if the addition of relative paths also made it easier to switch between data stored locally or in the cloud. Currently different commands are needed for files in the 2 places and the paths also differ because one uses \ and the other /!