'Status code: 416, description: 'The range specified is invalid for the current size of the resource.'

Status code: 416, description: 'The range specified is invalid for the current size of the resource.'. I am getting the above eror while load the data from azure blob storage. can any one help me out.



Solution 1:[1]

Several Blob service GET operations support the use of the standard HTTP Range header.
Many HTTP clients, including the .NET client library, limit the size of the Range header to a 32-bit integer, that limits to a maximum of 4 GiB.

Since both block blobs and page blobs can be larger than 4 GiB in size, the Blob service accepts a custom range header x-ms-range for any operation that takes an HTTP Range header.

I would suggest to look into Range Header Microsoft documentation.
Are you doing it with code or Azure Storage Explorer?

Solution 2:[2]

Thanks to user BigBen, since there's only one table in my worksheet, I can just refer to it by its ListObjects index, which will be 1. So then I can use something like:

.ListObjects(1).Name to update the name of the new table.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Fedeco
Solution 2 Icron