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
BUMP. This is a MUST! Wtf Microsoft.
RE: Support relative path to excel/csv sources
It is high time!!
RE: Support relative path to excel/csv sources
as an competitor of Qlik, i think it is really need to implement this function.
RE: Support relative path to excel/csv sources
just saw this has been open since 2015..............................
RE: Support relative path to excel/csv sources
Please add this ASAP!
RE: Support relative path to excel/csv sources
This is a basic implementation. I do not understand how this is not an option yet
RE: Support relative path to excel/csv sources
Fundimental software development 101. This should never have been an issue in the first place...yet here we are...waiting...and waiting.
RE: Support relative path to excel/csv sources
I'm a relatively new user. Loving PBI and working with big client companies that are not PBI users. I develop solutions and then it gets bogged down in the difficulty to transfer that solution. Do you know how many companies are not getting exposed to the beauty of PBI because this issue is not solved. Please make it happen.
RE: Support relative path to excel/csv sources
It's been over a year guys:
Bump this from the backlog to top of current sprint or top of the "Active Tasks" Kanban column, por favor.... It seems like everyone and their mother who writes scalable or deliverable code needs this.
Perhaps:
File.CurrentExecutionPath
File.CurrentPath
(Excel.CurrentPath would be too much trouble due to sharing)
RE: Support relative path to excel/csv sources
Please work on this. I am in an environment where I can not link to the source database and have to export all the info to Excel files before I can load them into Power BI. I am using Power BI to create daily reports and can not pass this on to the people that are actually responsible for those reports without constantly fixing data source locations or making sure that the user never moves a file once I fix the source location. Basically it cripples our use of Power BI.
Publishing is not an option because of strict IT policies. I would like to be able to just pass a folder to the user and tell them to just save over the appropriate Excel file with the new data. This way all the data and Power BI files are self contained in one folder.