Skip to main content
Solved

Acumatica and Power BI Integration Issue for a Single tenant of a multi tenant instance

  • 26 July 2024
  • 1 reply
  • 64 views

Currently we are experiencing an issue in Acumatica - Power BI Integration for a Single tenant of a multi tenant instance. The issue is as follows. Please check the below screenshot.

There are 2 tenants in this instance as  Test and Company. The connection for both tenants worked fine until recently. Now only for the Company tenant this above error is getting appeared. I examined all the GIs that have exposed via OData. In every GI there was no any field named DateCreated. There are no any significant difference in between these two tenants.  So can i know what's wrong with this Company tenant that cause this error.    

1 reply

Userlevel 4
Badge +1

It was found that an issue with the Parameters section of a GI that enabled the Odata is the root cause of this error. Mistakenly the usage of the same parameter name twice by the relevant GI creator was the issue. However, without proper warning, such a minor mistake causing the disconnection of the entire connection seems to be a significant point that should be considered by both systems.

Reply