Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Support relative path to excel/csv sources

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: Needs Votes
Comments
Lara_Balazs
New Member
Desperately needed!!
radoshits
New Member

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

KevinRank
New Member

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% .

rafael_vieira1
New Member

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


alkor1
New Member

hmm, was really surprised it is not supported yet

b_harper
New Member

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

seary
New Member

Need this for CSV/TSV/PSV flat files also.

fbcideas_migusr
New Member

Very shocked to know this is not supported!

matthieu_guerin
New Member

8 years after the first request, still not implemented.

nigray
New Member

Hitting this limitation in the case of pbix referncing xlsx on Sharepoint/OneDrive, and it's frustrating.