Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Surya9
Resolver III
Resolver III

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

1 ACCEPTED SOLUTION
Surya9
Resolver III
Resolver III

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".

View solution in original post

5 REPLIES 5
Surya9
Resolver III
Resolver III

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".

v-yalanwu-msft
Community Support
Community Support

Hi, @Surya9 ;

 

May be  it had to do with Relationships.

vyalanwumsft_0-1647246311378.png

https://community.powerbi.com/t5/Desktop/The-base-version-must-not-be-negative-when-impact-is-reques...

https://community.powerbi.com/t5/Desktop/Error-failed-to-save-modifications-to-the-server/m-p/290840

 

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

GilbertQ
Super User
Super User

Hi @Surya9 

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@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?

Hi @Surya9 

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors