Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
When using Web.Contents URLs over 2000ish characters in length have resulted in an error:
"The underlying connection was closed: the connection was closed unexpectedly"
Is this error caused by the length of the URL?
Solved! Go to Solution.
@Anonymous,
I haven't found any infomation about maximum URL for Web.Contents() function. For OData.Feed() function, there is a MaxUriLength property.
In your scenario, I would recommend you use Fiddler to track what is going on in the background.
Regards,
Lydia
@Anonymous,
I haven't found any infomation about maximum URL for Web.Contents() function. For OData.Feed() function, there is a MaxUriLength property.
In your scenario, I would recommend you use Fiddler to track what is going on in the background.
Regards,
Lydia
Thanks, it turns out that there is a limit to the URL length as part of the API.
I do have a follow on question related to the conversion of a GET request, which can't handle the URL length, to a POST request which should be able to. That question is posted here. If you are able to have a look at this it would be much appreciated.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 4 | |
| 4 |