Skip to main content
Solved

Power BI Refresh failed after upgrade to 2023R2

  • June 3, 2024
  • 3 replies
  • 154 views
  • Translate All

Forum|alt.badge.img

The refresh in Power BI on all reports running form Acumatica GI’s are being blocked after upgradeing to 2023R2 (build 23.211.0017 ).

For each refresh the following error occurs:

‘The field ‘BegPeriod’ already exisits in the record’

This message shows up for all reports where different GI’s are used with different tables.

 

Best answer by suemackeown13

Hi Chris

 

After the upgrade, some unrelated GI parameters were duplicated. After removing the duplicates, the report worked.

View original

3 replies

Forum|alt.badge.img

I am adding to my original post. It seems it is a connection issue.

When trying to create a new power bi report, the same error message is displayed when getting data foprm the OData feed:

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 11, 2024

Hi @suemackeown13 were you able to find a solution? Thank you!

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • July 12, 2024

Hi Chris

 

After the upgrade, some unrelated GI parameters were duplicated. After removing the duplicates, the report worked.

Translate