Skip to main content
Question

OData Error for PowerBI for only one GI

  • July 8, 2025
  • 3 replies
  • 58 views
K
Freshman II
Forum|alt.badge.img

My data sources from GIs have been automatically updating a PowerBI sheet. However, today one of them broke, and only one of them, with the error:

“DataSource.Error: We couldn't parse OData response result.  Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Details:
    DataSourceKind=OData
  DataSourcePath=https://company.acumatica.com/odata/Production/Sales%20Profitability%20Analysis%20Detailed.” 

I’ve attached the GI that’s causing the issue.

1 Attachments

    3 replies

    craig2
    Pro I
    Forum|alt.badge.img+3
    • craig2
    • Pro I
    • July 8, 2025

    Hi ​@kkraus ,

    Any chance there was an Access Rights change to either that GI, or whatever Role/User you use for ODATA connections?  That’s usually my culprit when a connection mysteriously stops working.

    Chris Hackett
    K
    Freshman II
    Forum|alt.badge.img
    • kkraus
    • Author
    • Freshman II
    • July 8, 2025

    Hi ​@kkraus ,

    Any chance there was an Access Rights change to either that GI, or whatever Role/User you use for ODATA connections?  That’s usually my culprit when a connection mysteriously stops working.

    Unfortunately no, ​@craig2. Administrator (which is the permission that the site is pulling via) still has access rights to the table.

    K
    Freshman II
    Forum|alt.badge.img
    • kkraus
    • Author
    • Freshman II
    • July 8, 2025

    Is there some place that I could look to get a more detailed error message? I can access the OData online, and refresh all the other sheets.

    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