When refreshing data from Business Central into Power BI Gold for Finance, a refresh error may occur due to how your Begin and End-Total accounts are configured in your Chart of Accounts
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Column 'G/L Account No.' in Table 'G/L Account' contains a duplicate value '<pii>2424</pii>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
If you receive this error, please review Begin and End-Total totalling in your Chart of Accounts.
Your totalling for an End-Total account must exactly reference both the Begin and End-Total accounts.
Fixing the Totalling on your Accounts
Begin and End-Total accounts should be set up such as the following example.
- A Begin-Total account of 1300 (Vehicles) and the End-Total account of 1390 (Vehicles, Total).
- The totalling defined on the End-Total is 1300..1390. If your totalling account is defined as any other combination (i.e. 1300..1340, 1310..1390, 1310..1340, etc), this will cause the error.