Reply
Frequent Visitor
Posts: 4
Registered: ‎08-08-2018
Accepted Solution

Failed to save modifications to the server. Error returned: 'The base version must not be negative

I am having the same error message again from a few weeks ago.  Cleared up when I rebooted my computer ??? but now back again.  If I knew what message meant perhaps I could fix issue.

 

"Failed to save modifications to the server. Error returned: 'The base version must not be negative when impact is requested for a transaction."

 

I had completed a BI file and was working fine but wanted to start from scratch to clean it up.  My original (3 months old) excel file has several tabs which are imported into BI.  When creating a new BI file with current excel file, all the tabs import okay from current monthly sheet except for one which has changed the least over the last few months.

 

I compared the two tabs in the files current and original and both are the same except for two rows of data.

 

What is odd is this !!

 

The original BI file still updates okay with the original file EVEN AFTER adding the 2 extra lines to the original excel file.

 

HOWEVER, if I delete that query file (tab from excel) in BI and try to reload the tab into Query Editor and BI file again, (from the original file), it too gives me the same error.

 

Only the update or refresh works without an error.

 

I did notice that the Query Editor in BI did not automatically use the first row as headers when the error occurred.  It does it correctly with all the other tabs.  I then tell Query Editor to use first row as header.  Even if I let first row be data or use a table for the tab, the same results.

 

I tried putting the tab info in a separate file and still got the same error.

 

Thanks for any help you can provide to fix or at least what message means. 


Accepted Solutions
Frequent Visitor
Posts: 4
Registered: ‎08-08-2018

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negat

 

Hi Lydia,

 

Thanks for the response.  I saw this issue last night on a more thorough Google search with the respective resolution noted below with the Options Settings. 

 

Evidently, it had to do with Relationships although you would never know that based on the error message. 

 

I tried today and it resolved the issue.  In fact, I can check the Autodetect afterwards again and it still works.

Thanks . 12-5-2018 11-52-37 AM.png

View solution in original post


All Replies
Moderator
Posts: 9,925
Registered: ‎03-10-2016

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negat

@RBDport,

Could you please share the source Excel file and original PBIX file via Private Message? I will test it in my Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator
Posts: 9,925
Registered: ‎03-10-2016

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negative - Status changed to: Needs Info

 
Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 4
Registered: ‎08-08-2018

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negat

 

Hi Lydia,

 

Thanks for the response.  I saw this issue last night on a more thorough Google search with the respective resolution noted below with the Options Settings. 

 

Evidently, it had to do with Relationships although you would never know that based on the error message. 

 

I tried today and it resolved the issue.  In fact, I can check the Autodetect afterwards again and it still works.

Thanks . 12-5-2018 11-52-37 AM.png

New Member
Posts: 1
Registered: ‎01-31-2019

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negat

I'm having this same issue with a SQL source. An older Power BI Desktop (pre appstore) works fine on the same source. Unchecking/rechecking the option box specified here does not resolve. Seems there's a bug here.

 

Frequent Visitor
Posts: 4
Registered: ‎08-08-2018

Re: Failed to save modifications to the server. Error returned: 'The base version must not be negat

I havent had any problems since my post and I have updated and modified my file several times.  Sorry I cant help you.

 

Best Regards

 

RBDport