Data Flow Gen1 ODataService Errors

[LuITS]

Hello,

i use multiple Dataflows Gen1 to red Data from an OData Service of our local ERP System.

Now i have a OData serivce where im not able to load the data. I don't know if the data of this ODataService is simply to big or there are other solutions.

The Tables i want to load have around 60 to 80 thousand rows and 200 Collumns.

I get errors in Datflow like:

-Unable to complete the request. Please retry again later, and if this issue recurs, check your network, proxy, vpn, or firewall configuration or contact your network administrator.

-Unable to read data from the transport connection: The connection was closed

-Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

-Request failed: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)

One Table is aaccessible, but it has only 8 thousand rows and the 200 collumns.

Interesting is:

I can load the ODataServices Excel, takes up to 15 minute with 400-500 MB

I can Preview data in Power BI Dektop Quety Editor, but can't load it into report
(Error: No Data could be read from source: Connection was closed)

Does someone has expierence with those issues or is my data just to big for ODataService in Dataflow Gen1?

[v-lgarikapat · Accepted solution]

Hi @LuITS ,

Thanks for reaching out to the Microsoft fabric community forum.

To troubleshoot ODataService errors in Power BI Dataflow Gen1, start by reducing the data size using select to limit columns and filter to limit rows, then try splitting the data into smaller chunks  to isolate load failures. Test small subsets in Power BI Desktop to confirm stability and identify thresholds. Ensure the on-premises data gateway is installed, updated, and not being blocked by firewall, VPN, or proxy settings. Check whether the OData service supports pagination via @odata.nextLink, and verify backend limits on payload size, timeout, or throttling with your ERP or network admin.

Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn

Troubleshooting dataflow issues - connection to the data source - Power Query | Microsoft Learn

Solved: Dataflows (Gen1 and Gen2) failing - Microsoft Fabric Community

Solved: Re: Dataflow Gen 1 not refreshing - Microsoft Fabric Community

If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @LuITS 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @LuITS ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @LuITS ,

As we haven’t heard back from you, we are closing this thread for now. If you are still experiencing the issue, please feel free to create a new thread we’ll be happy to assist you further.

Thank you for your patience and continued support.

If you found our response helpful, kindly mark it as Accepted as Solution so that others with similar queries can benefit from it.

Best Regards,

Lakshmi Narayana