Skip to main content
Solved

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

  • Jul 24, 2023 5:31 PM UTC
  • 3 replies
  • 1572 views
  • Translate All
michaelho
Semi-Pro III
Forum|alt.badge.img+1

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.

View original
2024 Acumatica MVP

3 replies

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+5
  • RohitRattan88
  • Acumatica Moderator
  • Jul 24, 2023 7:55 PM UTC

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

Translate
    michaelho
    Semi-Pro III
    Forum|alt.badge.img+1
    • michaelho
    • Author
    • Semi-Pro III
    • Answer
    • Jul 25, 2023 10:36 PM UTC

    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.

    Translate
    2024 Acumatica MVP
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Jul 25, 2023 10:52 PM UTC

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

      Translate
      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 & ConditionsAccessibility 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