Skip to main content
Answer

OData issue with Power BI (DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed)

  • July 24, 2023
  • 3 replies
  • 1330 views
M
Semi-Pro II
Forum|alt.badge.img

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.

Best answer by michaelho

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.

3 replies

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • RohitRattan88
  • Acumatica Moderator
  • July 24, 2023

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

Chris Hackett
M
M
Semi-Pro II
Forum|alt.badge.img
  • michaelho
  • Author
  • Semi-Pro II
  • Answer
  • July 25, 2023

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.

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 25, 2023

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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