Forum Discussion
PowerBi Desktop replace excel file
Hi, I recentaly edit my excel file source and I would like to replace it with my current excel file with out losing my dashboard relashanshoips. Any ideas how I can do that?
To simplfy, I like to replace the current excel file with an updated file?
Thanks,
Aviv
avivba Try to remove the column that is no longer there first from PBI, then refresh it.
7 Replies
avivba If the columns are the same you can just update the existing file that Power BI is connected to. If that doesn't work, you can edit the source info in Power BI to point at the new file and the data should update.
You may get breaking changes if the columns don't match up though.
Thanks for the replay,
The file is the same file but I add columns and rows, which mean I need to replace the source.
How I can edit the source info in Power BI to point at the new file and the data should ?
Thanks,
Aviv
avivba You can do this in two ways.
1) Edit Queries -> Highlight the Query (table) you want -> Click on the Wheel icon to the right of "Source" under the "Applied Steps" on the far right. This will pop up you initial connection and you can replace it.
2) Edit Queries -> Highligh the Query (table) you want -> click on "Advanced Editor" in the top ribbon -> Find and replace the data file path.
