Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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".
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".
Hi, @Anonymous ;
May be it had to do with Relationships.
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.
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?
@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 @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?