It's possible to get the current folder path of a file using a formula in Excel. This value can then be passed into Power Query. This works fine for data models and visualizations built entirely in Excel. If the model is built in Power BI Desktop, there's currently no method to land this data into the data model.
3 Comments
- This is an important feature to get all of the sources in the same folder as the .pbix file.
fVossAdvocate I
I think this idea could be merged with the one in the following link https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9665565-support-relative-path-to-excel-csv-sources- Status added:Needs Votes
