983
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)
STATUS DETAILS
Needs Votes

Comments

B

Pesky analysts asking for complicated features like relative paths. Microsoft developers can't cater to every niche edge cases!

B

hmm, was really surprised it is not supported yet

B

Please add relative path capabilities!


As sugestion:


“/” - returns to the root directory and starts there

“../” - moves one directory backwards and starts there

“../../” - moves two directories backwards and starts there (and so on…)


To move forward, just start with the first subdirectory and keep moving forward


B

This is feature I could REALLY use.


Another option, would be relative paths, or the ability to use standard windows environment variables that have been around for a VERY long time. (Honestly, this is one I seriously don't understand why it is not available). Then, I could have users store their excel files in their %userprofile% .

B

This is a must have feature, now that you allowed having scheduled refresh on Excel file on One Drive.

B

Desperately needed!!

B

I can't believe this is not implemented yet!

B

Power BI Desktop should have a Power Query keyword (like #shared), called something like #workingdirectory, which returns the current report file's working directory as an absolute path. That way, you wouldn't even need to use the report parameters at all. You'd just edit the Source line in the M query to look like this:

Source = Excel.Workbook(File.Contents(#workingdirectory & "ExcelFile.xlsx"), null, true)

Then, as long as the report PBIX and its data source files are kept together, and the source file names stay the same, the report will just work automatically, no matter who opens it or where it's saved in the filesystem. 😎thum

B

How come this is a not feature... This should've been implemented years ago.

B

PowerBI is an exceptional tool, BUT developers need to change their mindset: advanced users? we are enthusiastic but too few to blow other tools (like QlikView or even think-cell) out of the water. The average user will always be unable to get inside the model and make changes without making a mess, but they are the many.

I spend a good part of the day explaining (among other basic things, like resetting filters) why they shouldn't change the folder the files are stored in, and how to change file paths, problems I didn't have with QlikView (Oh how I miss the old . and .. folder commands)

At this point, basic features such as this one should've been addressed.