Power BI

Needs Votes

Support relative path to excel/csv sources

Vote (1151)

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

Comments (87)

Power BI User on 05 Jul 2020 23:57:46

RE: Support relative path to excel/csv sources

Please support Relative paths. I loose a lot of productivity hours at the moment by not having this available.

John on 05 Jul 2020 23:57:21

RE: Support relative path to excel/csv sources

I have the same issue with Access files

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!!