Forum Discussion
'The base version must not be negative when impact is requested for a transaction. '.
- 7 years ago
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
- 7 years ago
Thanks Anonymous! 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
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.

- mibu7 years agoMicrosoft Employee
Thanks Anonymous! 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
- Anonymous6 years agoNot applicable
I got the same error, after so many attempts i tried by changing relationship from 'both' to 'Single' and error gone. this is not I want. but as there is no other solution.
we are using PBIRS Sept 2019 version.