Forum Discussion

avivba's avatar
avivba
Regular Visitor
9 years ago
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...
  • Anonymous's avatar
    Anonymous
    9 years ago

    avivba Try to remove the column that is no longer there first from PBI, then refresh it.

avivba's avatar
avivba
Regular Visitor
9 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

avivba If it's the same file just refresh the query...

  • avivba's avatar
    avivba
    Regular Visitor
    9 years ago

    Unfortenatly it dose not paull the new rows I add and give me an error message on the column I removed, any idea way?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      avivba Try to remove the column that is no longer there first from PBI, then refresh it.