Skip to main content

    Power BI

    Needs Votes

    Support relative path to excel/csv sources

    Vote (727) Share
    Boris Lipschitz's profile image

    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 (59)
    Boris Lipschitz's profile image Profile Picture

    ab9f6d44 19fe-4a4b-bf7c-c22dcd8a1368 on 05 Jul 2020 23:59:40

    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.

    Boris Lipschitz's profile image Profile Picture

    2d904933 0d32-4bed-8395-62a9a7ad0442 on 05 Jul 2020 23:58:08

    RE: Support relative path to excel/csv sources

    Dudes, sort this out! It's killing me!

    Boris Lipschitz's profile image Profile Picture

    e982d8da 3c2a-406b-85b7-b7fe20aa1ffc 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.

    Boris Lipschitz's profile image Profile Picture

    2baf1fe8 bc7b-49f1-ac76-43fd23bbda4d on 05 Jul 2020 23:57:21

    RE: Support relative path to excel/csv sources

    I have the same issue with Access files

    Boris Lipschitz's profile image Profile Picture

    712d8ba6 0a68-4c33-9e2e-b6abc13ea10d 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.

    Boris Lipschitz's profile image Profile Picture

    88b58fdc 6dd7-426f-bd2a-06fd4f908d7f 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!!

    Boris Lipschitz's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    Boris Lipschitz's profile image Profile Picture

    341c5785 d9a1-4f33-8b45-0cdf984ca1c1 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.

    Boris Lipschitz's profile image Profile Picture

    1b37ef4d 765e-4e0a-8473-05aed4623b9b on 05 Jul 2020 23:52:12

    RE: Support relative path to excel/csv sources

    Please add this feature.

    Boris Lipschitz's profile image Profile Picture

    f1b3ac6a 4733-4c1d-94ed-27898e2e31a4 on 05 Jul 2020 23:52:12

    RE: Support relative path to excel/csv sources

    Please add this!