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

Finance App PowerBI Refresh Failure

(5) Share

Report

Posted on by HM-22101606-0

I am getting the following with the built in PowerBI Finance Report. Its the standard report, which is plug& go, why am i seeing this? It worked previously - Running BC version 26.5. I have seen it was a known issue in previous versions & fixed in BC26 but as you can see its still happening.

There is only 1 GL Account 205001

An error occurred while processing the data in the semantic model.

Refresh failed:

Finance app has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
Column '<oii>G/L Account No.</oii>' in Table '<oii>G/L Account</oii>' contains a duplicate value '<ccon>205001</ccon>' 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 Account.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 93,153 Super User 2025 Season 2 on at

Like (4)

Report

Finance App PowerBI Refresh Failure

Looks like a standards issue, I suggest submitting it to Microsoft.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 5,031 on at

Like (2)

Report

Finance App PowerBI Refresh Failure

Hi,

Does your environment have multiple companies enabled? This helps determine if the duplicate key error is due to cross-company data or a model issue.

Thanks

Rishabh

Was this reply helpful? Yes No
HM-22101606-0 20 on at

Like (3)

Report

Finance App PowerBI Refresh Failure

Only 1 live company in PROD, only 1 finance app, & 1 workspace

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 742 on at

Like (3)

Report

Finance App PowerBI Refresh Failure

Hello,

A lot of users are reporting this, I suggest to open a ticket with Microsoft

Regards,
Oussama

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 7,958 on at

Like (1)

Report

Finance App PowerBI Refresh Failure

Hi,

Similar kind of issue raised earlier also, I think in March 2025 (sharing link below) but not having verified answer:-

Power BI Dynamics 365 Business Central Finance Reports - Error when trying to connect data from BC

As suggested by other experts, please raise a support ticket with Microsoft.

https://support.serviceshub.microsoft.com/supportforbusiness/create

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,312 Super User 2025 Season 2 on at

Like (2)

Report

Finance App PowerBI Refresh Failure

Agree with the previous responses. You should raise a ticket with Microsoft.

Was this reply helpful? Yes No