Error on Finance Power BI Report on setup/refresh

(9) 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

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Henrique_Mendes 38 on at

Like (1)

Report

I'm having the same problem. Did you find a solution?

Was this reply helpful? Yes No
CU07120857-0 59 on at

Like (2)

Report

Hello Yun Zhu,

This Power BI report is linked automatically because it is an official pre-made report.
I also checked the table, and there are no duplicates.

Unfortunately, I still haven't found a solution.
Is there a place where I can give feedback to the maintainers of these reports?

Thank you in advance.

Best regards
M

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (3)

Report

Hi

Does the message appear in all companies and/or all environments?

Best

GR

Was this reply helpful? Yes No
Henrique_Mendes 38 on at

Like (2)

Report

For me I get it in all environments.

I could trace the G/L movement by his Number and it's the Closing Statment. Anyway can not see a ducplicate value on the primary key on BC.

Was this reply helpful? Yes No
Verified answer

Henrique_Mendes 38 on at

Like (6)

Report

Seems to be a bug on the Semantic Model: Set up the Finance Power BI app - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,347 Super User 2025 Season 2 on at

Like (2)

Report

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/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-to/m-p/68775

Was this reply helpful? Yes No
mwoodward 6 on at

Like (2)

Report

Same issue here - any news on when this wil be fixed?

Was this reply helpful? Yes No
CU28021803-0 7 on at

Like (2)

Report

I'm having the same problem in ES Version. Did you find a solution?

Was this reply helpful? Yes No
goranplavsic 24 on at

Like (2)

Report

We're still experiencing the same issue listed under known issues. Has anyone found a solution? Or does Microsoft have plans to fix this bug soon? It would be really helpful if Microsoft could provide a workaround or release a fix, as this report is currently unusable. :-(

Was this reply helpful? Yes No