Forum Discussion
Solved
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 re...
avivba Try to remove the column that is no longer there first from PBI, then refresh it.
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