Power BI

Needs Votes

Support relative path to excel/csv sources

Vote (1112)

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 (83)

Comments (83)

Amr IBRAHIM on 17 Mar 2021 20:58:29

RE: Support relative path to excel/csv sources

This needs to be Implemented ASAP, we can't even get the path of current folder........

Mircea Ontanu on 08 Jan 2021 16:17:27

RE: Support relative path to excel/csv sources

This is so basic but missing for such a long time. How should I teach a non technical person to update the path that points to a file next to the template full of pivots. Such a pain. I just want to send to the client a template report and the data csv file. They should open the report but it will fail because the path to the data is not the same as on my computer. Yeah one solution would be to put the data in the same excel file, but then.. they have to copy paste the new data when is necessary and click refresh all.

Wayne Harrison on 21 Oct 2020 13:42:41

RE: Support relative path to excel/csv sources

I'm amazed still that after 5 years that this still isn't there! - I'm up voting this for two reasons, yes to the original idea of relative paths but also to be able to query where the currently opened PBIX file was loaded on, that way there is a small change to go update the content of the 'variable' work around that's been used FOR THE LAST FIVE YEARS to just read where the PBIX was loaded from instead. Best of both worlds then!

Prodegee TTA on 13 Oct 2020 18:04:48

RE: Support relative path to excel/csv sources

Support a relative path is not an idea, is a BASIC feature and the fact that it is not yet there tells me that MS has no interest in Power BI being used.

E Daugherty on 14 Sep 2020 21:43:32

RE: Support relative path to excel/csv sources

This would be especially helpful for those getting data from R, where the preferred practice is to leave the default working directory alone. This means any file paths used will be relative to that default wd.

David Rychlý on 12 Aug 2020 20:28:35

RE: Support relative path to excel/csv sources

After five years of still missing this core functionality for any software working with external files. Microsoft, you should finally start thinking about the usability of your products...