Power BI

Needs Votes

Support relative path to excel/csv sources

Vote (1111)

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)

Brian on 05 Jul 2020 23:56:30

RE: Support relative path to excel/csv sources

It is beyond my comprehension how this seemingly obvious ask goes unanswered all this time given the consistent updates PowerBI enjoys. .\ ..\ following symlinks is not rocket science. And there is a valid use for this which the service does not address. Consider proof of concept design phases, or grassroots level projects that incubate innovation before online data services exist. I love this tool but the archaic design choices like this are unnecessarily annoying at times and are an impediment to user innovation.

AM on 05 Jul 2020 23:55:46

RE: Support relative path to excel/csv sources

My non-technical users constantly fight with this issue, it's consuming lots of our resources.

We need a way to easily accommodate per-user pathnames at data query time.

Thanks!!

Power BI Ideas Admin on 05 Jul 2020 23:55:36

RE: Support relative path to excel/csv sources

Indispensable feature when multiple people need to develop and development on a server is not a possibility

Power BI User on 05 Jul 2020 23:54:12

RE: Support relative path to excel/csv sources

This is becoming a deciding factor in choice of BI.

Florian on 05 Jul 2020 23:52:12

RE: Support relative path to excel/csv sources

Please add this feature.

Michael on 05 Jul 2020 23:52:12

RE: Support relative path to excel/csv sources

Please add this!

Bilal Mansoor on 05 Jul 2020 23:52:11

RE: Support relative path to excel/csv sources

Surprising that this isn't already available

Thomas Reasoner on 05 Jul 2020 23:51:23

RE: Support relative path to excel/csv sources

Absolute paths are rarely ever useful. Relative paths should be the default.

Power BI User on 05 Jul 2020 23:50:34

RE: Support relative path to excel/csv sources

This capability exists in Excel. . .should also exist in Power BI

Joe Natarajan on 05 Jul 2020 23:47:19

RE: Support relative path to excel/csv sources

I have many pbix files about 50 where I manually filter out the data using a text value. If I can have that value in the pbix file name I can get the file path and then parse it and pass it to the filter in power query. Something like var = thispbix. path