Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi,
I'm connecting to an SAP OData feed:
OData.Feed("https://myxxxxxx.sapbydesign.com/sap/byd/odata/cpm_corporateperformance_analytics.svc/XXXXXXXXXXXXQu... ne '00043' or CACCDOCTYPE ne '00058') and (CPOSTING_DATE ge datetime'2024-01-01T00:00:00' and CPOSTING_DATE le datetime'2024-01-31T23:59:59')&$top=99999&$format=atom", null, [Implementation="2.0",Timeout=#duration(0,0,10,0)])
The query is returning 8600 rows and 12 columns. The query works fine when launched on Excel or Browser, but PowerBI returns "Existing connection forcibly closed by the remote host". This is frustrating as the queries worked before with larger datasets (tens of thousands of rows), but now this is getting ridiculously small. What is the issue here? It seems like a PowerBI side issue, since the queries work when launched on other platforms.
@lbendlin has pointed a direction, you can try provide a larger timeout value in the query.
If it doesn't help, here is another direction: try only connect to the root OData endpoint and then navigate and filter inside Power Query.
For example, connect to
https://myxxxxxx.sapbydesign.com/sap/byd/odata/cpm_corporateperformance_analytics.svc/XXXXXXXXXXXXQueryResults
or
https://myxxxxxx.sapbydesign.com/sap/byd/odata/cpm_corporateperformance_analytics.svc
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
how fast do you get the error message back? after 10 minutes?
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
7 |
User | Count |
---|---|
43 | |
26 | |
21 | |
16 | |
12 |