Support relative path to excel/csv sources

[borlip]

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)

[konradmd]

Wondering that this currently is not working, since the 'M'-documentation shows example code with local (Excel) file loadings.

[alasdair3]

This feature is extremely useful when users need to send .pbix files to each other. I have to do this all the time as a consultant and have to use a messy workaround every time. In power Query this was done using Parameter tables... perhaps implementing this feature in Power BI would solve the issue?

[KirkNason]

To add to this suggestion, we need to be able also change the path to files like .csv, .txt etc when setting up the refresh schedule. If you think of standard dev / QA / Prod scenarios it would be common for the server name(s) and references to files to change. In my case I developed on my own machine. Then moved the .csv and .pbix files to the customers PBI Group OneDrive. As you can imagine the connections/paths are different, I had to have the customer, download and open the .pbix file and change the path to the OneDrive location for the .csv files, then use “Import - Files” to load the .pbix file into the PBI Group. It would have been easier to edit the path in the Personal Gateway Scheduling screen.

[fbcideas_migusr]

I Agree, I came to post on relative path. I would like to be able to place source files in the same folder or sub folder, and then be able to pass the files to someone else who can then put the group wherever they would like. In my current scenario I use an excel file like an .ini so that the user side can modify aggregating source paths as they become available.

[neville_collins]

This would be a great feature of PowerBI. Easily done with Power Query in Excel, but need the same in PowerBI please.

[travbum]

Sharing .pbix files is very frustrating when the first step is to go in and modify all the absolute paths.

[fbcideas_migusr]

Fully support, good idea!

[mira_bella]

I agree!! It would make so much easier for my colleagues to update the files independently on their own machines... Wonder why isn't this working now.

[mark59]

Hi there, I would appreciate this feature. We are trying to deploy a dashboard template with the data source in the same folder. For my teammates it would be very helpful, not to change the source path.

[andre_armenni]

I cannot stress how important this is. Upvoted!