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

[mibu]

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

[mibu · Accepted solution]

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