Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

I have a report where i am using incrmental refresh. 
but the size of table on which the incrmental refresh is applied is very big, so instead to direct refresh from service i am trying to create the partitions and then refresh the partions individually and then set the schedule refresh. 
but the problem is when i try to apply the refresh policy using tabular editor 2 to create the partitions i got the error 
"The action failed with the following error: Failed to save modifications to the server. Error returned: 'The base version must not be negative when impact is requested for a transaction."
Can someone help me with this. or any other better approach to create the partitions

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    This problem was because of not inserting propper connection connection string while connecting Power bi service with tabular editor.
    I had entered the another report connection string there thats why it gives an error that "The base version must not be negative".

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This problem was because of not inserting propper connection connection string while connecting Power bi service with tabular editor.
    I had entered the another report connection string there thats why it gives an error that "The base version must not be negative".

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    Just to confirm you are using Power BI Premium per user or Premium?

     

    If you are you can then upload the PBIX to the Power BI Service.


    DO NOT REFRESH THE DATASET, because that will set in motion the events to create the partitions.

     

    What you can then do is to go in using Tabular Editor 2, then click the "Apply Refresh Policy"

    That will then create all the partitions.

    Now using SQL Server Mangement Studio connect to the dataset.

    Then right click on the table with the incremental partitions, then select Partitions.

    From there now process each Partition in Full?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      GilbertQ Thanks for your reply 
      I am using Power BI Premium.
      Yes, I am also using this same step to create partitions. 
      but this time when I click the "Apply Refresh Policy" I got the Error 
      "The action failed with the following error: Failed to save modifications to the server. Error returned: 'The base version must not be negative when impact is requested for a transaction."
      Do you have any idea how to fix this?

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        4 years ago

        Hi Anonymous 

         

        I have never seen that error, I have no idea why that is happening?


        The only thing I cna think of is either there is an older version of Power BI Desktop being used.

        Or if there is something else that was edited in Tabular Editor that is not supported?