Forum Discussion
PowerBi Desktop replace excel file
avivba Try to remove the column that is no longer there first from PBI, then refresh it.
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.
The file I am traying to replace is the same file, which mean the same location.
I am going into, Edit Queries, and I have two queries on the left side - Query Errors & Other Queries, which one I should work on?
Going throgh the steps, I can replace the path, but since it is the same file I don't see any change - Should I save the updated file under a diffrent name at a diffrnet path?
Thnaks,
Aviv