Small and medium business | Business Central, N...

error when synchronizing data to power bi

(2) Share

Report

Posted on by SR-05080922-0

Hi!

I want to connect my production company to power bi financial report.

But the connection fails due to the following error:

Data source error: Column '<oii>Entry No.</oii>' in Table '<oii>G/L Entries</oii>' contains a duplicate value '122154' 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. Table: G/L Entries.

But when I check in the database, I can find only one entry with the entry no. 122154 in G/L Entries...

Thank you for your help!

Best

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

Noha Mbi 276 on at

Like (0)

Report

error when synchronizing data to power bi

Hello dear,

Have a nice day, I have encountered this error before and this was the solution, (indenting the chart of account properly so the (totaling) field will be distributed right)

Hope this help,

Regards

Noha - MS Certified BC Developer
Suggested answer

Jainam M. Kothari 7,921 on at

Like (1)

Report

error when synchronizing data to power bi

Hello,

To resolve the error when connecting Business Central to Power BI, ensure there are no hidden duplicates in the Entry No. column of the G/L Entries table by running a query to check for duplicates.

Verify that the relationships in Power BI are correctly set up, refresh the data source, clear the cache, and check for any data integrity issues in your Business Central database.

Using Power BI Desktop can also provide more detailed error messages and debugging options.

May this can help : https://community.fabric.microsoft.com/t5/Desktop/Refresh-error-quot-contains-duplicate-value-and-this-is-not/m-p/588890

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-create-a-Power-BI-report-using-Business-Central-Data/ba-p/3336403
Suggested answer

Khushbu Rajvi. 16,318 Super User 2025 Season 1 on at

Like (3)

Report

error when synchronizing data to power bi

If this helps: https://community.fabric.microsoft.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-to/m-p/68775