Error on Finance Power BI Report on setup/refresh

(1) Share

Report

Posted on by CU07120857-0

Hello,

I really like the idea of using the prebuild Power BI Reports for Business Central. But it seems that there is a problem with a relationship in the semantic model.

This is the report: https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-financial-overview

Error message:

Data source error: Column '<oii>Entry No.</oii>' in Table '<oii>G/L Entries</oii>' contains a duplicate value '30195' 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.
Cluster URI: WABI-GERMANY-WEST-CENTRAL-PRIMARY-redirect.analysis.windows.net
Activity ID: cf9fa7fc-aeac-a168-d7aa-309fe98b2a8c
Request ID: 028b8b25-7ee2-cfdf-edb8-c3b669d607fc
Time: 2024-12-07 08:27:24Z

Did someone have the same error and found a solution? When I checked for a duplicate value, I could not find one in Business Central :(

Best regards,

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

Entry No. is the primary key of table G/L Entries. It is impossible to have a duplicate in BC. This should be a problem with the API/Web Service you linked to, or the value in Power BI.

Please do not look directly at the table in BC, open the page you linked and see if the value is repeated.

Hope this can give you some hints.

Thanks.

ZHU