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
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, @Surya9 ;
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 @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?
@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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.