cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

'The base version must not be negative when impact is requested for a transaction. '.

Hi Everyone,

 

I am simply trying to pull in a simple dimension Excel file...  like I have done many times before...  and am getting the following error message:

 

Failed to save modifications to the server. Error returned: 'The base version must not be negative when impact is requested for a transaction. '.

 

Pls let me know if you have had any experience with this error message.

 

Thanks!

mibu

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Hi @jagatho,

 

Thanks so much.  Your feedback gave me the idea to Match Exactly the headers of the Excel Dimension file I have been trying to load…  with the corresponding column of the Cube to which I am connecting.  In previous attempt where I got afore mentioned error message, they were not named identically, not even close.

 

Naming columns identically in both files…  allowed Power BI to load the Excel Dimension file without an error message.  Funny, it did not autodetect the relationship between the newly named column in my Excel Dimension file and corresponding column in Cube.  No matter…  I was able to create the relationship manually, Close & Apply, and again, no error message.  I am back up and running.

 

Again, thanks so much for your feedback…  it spurred the thought that lead to a solution.

 

Very best,

mibu

View solution in original post

Highlighted

Thanks @Beat!  I appreciate the feedback.

 

I also found that Deleting all rows under last line of data in table...  and deleting all columns to the right of last column of data in table, eliminated the error message and allowed Refresh to occur.

 

best,

mibu

View solution in original post

11 REPLIES 11
Highlighted
Community Support
Community Support

@mibu,

 

Check this post and create a support ticket if necessary.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi @v-chuncz-msft,

 

I removed the filters from the source Excel file and continue to get the same error message, attached.Capture.PNG

Highlighted

I have created a support ticket and will advise if I get an answer.

Highlighted

Hi Mibu,

 

Was a resolution provided for this error?  I just received this today. 

 

Thanks,

Meg

Highlighted
Frequent Visitor

It has to do with the auto detection of relationships.

If I remove the column that would make sense that Power BI would predict having a relationship between tables and added a new one with the same name with null values in two PowerQuery steps, then I can load the data.

After the initial load I can remove the two steps and everything works, because it only tries to detect relationships on the initial load.

Highlighted

Hi @jagatho,

 

Thanks so much.  Your feedback gave me the idea to Match Exactly the headers of the Excel Dimension file I have been trying to load…  with the corresponding column of the Cube to which I am connecting.  In previous attempt where I got afore mentioned error message, they were not named identically, not even close.

 

Naming columns identically in both files…  allowed Power BI to load the Excel Dimension file without an error message.  Funny, it did not autodetect the relationship between the newly named column in my Excel Dimension file and corresponding column in Cube.  No matter…  I was able to create the relationship manually, Close & Apply, and again, no error message.  I am back up and running.

 

Again, thanks so much for your feedback…  it spurred the thought that lead to a solution.

 

Very best,

mibu

View solution in original post

Highlighted

Hi @mmccullough, check out last post in thread for a possible solution. best, mibu

Highlighted

Restart your device

Highlighted
Resolver I
Resolver I

I run into this problem yesterday and found the solution on StackOverflow.

 

In File, Options, Current File, Data Load, Relationships disable Autodetect new relationships after data is loaded.

 

 

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors