Row Definition Errors in Business Central Financial Reporting

If you encounter an error related to row definitions when importing financial reports into Power BI, follow these steps to identify and fix the issue.

Step 1: Identify the Problem Row Definition

1. In Business Central, use the search bar and type: Row Definitions, then click (Financial Report) Row Definitions.

2. Open the list and locate the row definition mentioned in your error message.

   • Example: If your error mentions "M-INCOME", find this specific row definition in the list.

3. Select it and click Home → Edit Row Definition.

4. Then "No" do not make a copy in the pop up that follows.

5. Inside the row definition, carefully check for these common causes of errors:

6. Duplicate Row Numbers

   • Two rows having the same row number will cause an error.

7. Incorrect Formula References

   • A formula that references another formula incorrectly, such as: The same row appearing twice in one formula.

Tip: Scroll through the rows carefully to spot these issues.

Step 2: Export to Excel (If You Need Help)

If you can’t find the issue:

1. Click Open in Excel from the top right menu.

2. Save the Excel file to your computer.

3. Send the file to support@eknowtion.com so it can be reviewed and the exact issue can be identified for you.

Step 3: Temporarily Fix the Error (Optional)

If you need to stop the error from showing up immediately, you can exclude the problematic report from being imported into Power BI:

1. Go to Finance → Financial Reporting.

2. Select Edit List.

3. Locate the report that uses the problem row definition (e.g., M-INCOME).

4. Check the option Exclude from Power BI.

This prevents the report from being imported, so the error will no longer appear, while you work on fixing the issue permanently.