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)
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.
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!
RE: Support relative path to excel/csv sources
Hi, I need this feature. It will make my work scalable.
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 /!
RE: Support relative path to excel/csv sources
This would be a nice usability feature. A simple checkbox on the file dialog box would suffice.
RE: Support relative path to excel/csv sources
Dudes, sort this out! It's killing me!
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.
RE: Support relative path to excel/csv sources
I have the same issue with Access files
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.
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!!