Skip to main content
Solved

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

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 mikeho

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
Did this topic help you find an answer to your question?

3 replies

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • RohitRattan88
  • Acumatica Moderator
  • 252 replies
  • 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
2 people like this
  • Chris Hackett
    Chris Hackett
  • M
    mikeho
M
Semi-Pro II
Forum|alt.badge.img
  • mikeho
  • Author
  • Semi-Pro II
  • 228 replies
  • 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
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2751 replies
  • 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*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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