FIX: Power BI error The base version must not be negative

One common Power BI error is  The base version must not be negative. Most users report that they failed to save the modification to the server because of this error. Furthermore, they encounter this error while trying to add another table to their project.

There are different ways to fix this error. Follow the steps over to solve the issue quickly.

The base version must not be negative error in Power BI

1. Turn-on Autodetection of Data Load

Turning on ‘Auto-detection of the relationship after data load’ can help you to avoid this error. Sometimes, this issue can reoccur even if you have autodetection on. Then follow these steps:

1. Go to the Options.
2. In the Current File section, select the Data Load.
3. There you shall see many other options. Under Relationship, there will be an option of autodetection. Uncheck the option shown.
4. Apply the settings.
5. Again repeat the above steps if you are directed to 1st step.
6. Recheck the option “Auto-detect new relationship after data is loaded”.
7. Apply the settings again.
8. Alternatively, after this, you can disable Autodetect and look for improvements.

This guide will help you become an expert in Power BI. Check it out now.

2. Making changings in the Excel source

This Power bi error also occurs while updating data. As mentioned above, a message appears that your base version should not be negative. Many users don’t pay heeds to match headers exactly same with the corresponding column of the cube to which they are connecting.

1. Name the column Identical to each other, in the source file and the cube.
2. Sometimes, the new relationship does not get load automatically. In that case, you have to load it manually.
3. Apply the changes and close.

3. Deleting Rows and Columns

1. Go to the last line of data in the table.
2. Delete all the rows under the last line of the data in the table.
3. Go to the last column of data in the right of the table.
4. Delete all columns to the right of the last column.

By following the above-mentioned methods, you can easily fix this Power bi error The base version must not be negative.

RELATED STORIES YOU SHOULD CHECK OUT:

• How to change the data source in Power BI [EASY STEPS]
• Download Power BI Desktop from the Windows Store to create interactive reports
• How to add filters in Power BI [EASY STEPS]