Business performance analytics self-help
To maintain the accuracy of report data, business performance analytics assesses the quality of the source data. If the assessments don't meet defined rules, business performance analytics logs information in the Bpa self help logs table in Microsoft Dataverse. This table provides insights into issues and helps you take appropriate action.
Access the business performance analytics self help logs table
To access the Bpa self help logs table, follow these steps.
- Open the Power Apps maker portal.
- Go to Tables > All.
- Search for BPA\Self\Help\Logs.
Understand the "Bpa self help logs" table
| Sno | Column name | Description |
|---|---|---|
| 1 | LogCode | The unique code of each error or warning. |
| 2 | LogName | The description of each error or warning. |
| 3 | LogType | This field can have two values:
|
| 4 | LogDetails | Details about records that have errors or warnings. You can use this information to take appropriate action. |
| 5 | Microsoftdocsurl | Use this URL to go to public documentation that can help you troubleshoot the issue. |
| 6 | Createddate | The date when the record was logged in the table. |
Note
- Errors affect report accuracy and require immediate attention.
- Warnings aren't critical but can affect report accuracy. If they're aligned with a valid business context, consider adjusting reports for accurate data representation.
For information about specific errors or warnings, see the following articles:
- Missing fiscal calendar for general ledger: Error code: ERR00001 [Type: Error]
- Missing fiscal calendar for budget: Error code: ERR00002 [Type: Error]
- Missing main account in budget: Error code: ERR00003 [Type: Warning]
- Missing journal entries: Error code: ERR00004 - [Type: Warning]
- Mismatch between debits and credits: Error code: ERR00005 [Type: Warning]
- Missing budget data: Error code: ERR00006 [Type: Warning]
- Missing budget transaction header: Error code: ERR00007 [Type: Warning]
- Missing foreign key reference: Error code: ERR00008 [Type: Warning]
- Entity dataframe counts differ between prejoin and postjoin: Error code: ERR00009 [Type: Warning]
- Missing main account in general ledger: Error code: ERR00010 [Type: Warning]
- Decimal limit exceeded: Error code: ERR00011 [Type: Warning]
- Decimal auto rounding: Error code: ERR00012 [Type: Warning]
- Null check violation: Error code: ERR00013 [Type: Warning]
- Null join violation: Error code: ERR00014 [Type: Warning]
- Data quality error: Error code: ERR00015 [Type: Warning]
- Output table is empty: Error code: ERR00016 [Type: Info]