Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. 

  • Anonymous's avatar
    Anonymous
    7 years ago

     

    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 . 

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

     

    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 . 

    • MazenBi's avatar
      MazenBi
      New Member

      It's still giving me the same error message, even after I have unselected and then selected again the "Autodetect new relationships after data is loaded".

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi All I am getting this Error Failed to save modifications to the server. Error returned: 'Table 'LocalDateTable_ae12710d-4f94-4271-80e5-da1af6488cf3' with ShowAsVariationsOnly property set to '1' must be a target of a variation when variation notation is enabled. Use all Option but not able to resolve. I wont lend up rebuilding pbix 😞

    • cdipierr's avatar
      cdipierr
      New Member

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        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