Skip to main content

We’ve been using Power BI to connect to Generic Inquiries via OData for the past year. All of the sudden in the past few days we’ve received the following error message in Power BI:

 

Anyone know what might be causing this and how to resolve the issue?

I found this article that references a similar issue, but none of our GIs have a period (.) in the name so the solve offered in the article isn’t helpful in this case.

Try testing connection and data retrieval in POSTMAN first then try to get the detailed error for further investigation. Error 500 may be caused by many things. Maybe post full error response here to detailed help.

Cheers

Thank you for that suggestion, @RohitRattan88! We tested in Postman and the API was able to connect without issue. We eventually found that there was a schema field in a GI that was causing the issue; once we removed that schema field the OData feed was accessible again.

Thank you for sharing your solution with the community @mikeho!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved