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.
Looks like a standards issue, I suggest submitting it to Microsoft.
Thanks.
ZHU
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.