Error on Finance Power BI Report on setup/refresh

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

Answers (1)

Suggested answer

Gerardo Rentería Ga... 19,066 Most Valuable Professional on at

Like (1)

Report

Error on Finance Power BI Report on setup/refresh

Hi, good day

This bug will be fixed in version 26 only.

Viva Engage : Dynamics 365 Business Central Partner Community (Formerly: Development) : Ver conversación

Best Regards
Gerardo
goranplavsic 20 on at

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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. :-(
CU28021803-0 3 on at

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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

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

Like (1)

Report

Error on Finance Power BI Report on setup/refresh

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
Verified answer

Henrique_Mendes 28 on at

Like (4)

Report

Error on Finance Power BI Report on setup/refresh

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

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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.
Gerardo Rentería Ga... 19,066 Most Valuable Professional on at

Like (2)

Report

Error on Finance Power BI Report on setup/refresh

Hi

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

Best

GR
CU07120857-0 35 on at

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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
Henrique_Mendes 28 on at

Like (0)

Report

Error on Finance Power BI Report on setup/refresh

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