Azure Blob Storage 404 Error

[picknotts]

Hi all. I'm attempting to connect to a blob container that's inside a storage account which is part of a resource group. I've set the access key in Power Query for that connection. The blob container access level is set to Blob - Anonymous. I can connect to other containers within the storage account; however, when connecting to the container I want it gives me a 404 error - specified resource was not found. In power query, when I set the source as the link to this container all the data shows in preview but when attempting to save and apply, I get the 404 error. Have you faced this problem before and if so, what did you do to resolve this? 

[mykle714]

Hi, I'm experiencing a similar issue. The previous reply didn't help as I'm sure I have the capitalization correct. I had a weird experience where it did actually connect the first time, but every time since, it was unable to find my azure blob. My steps are: Get data -> More -> Azure blob storage -> *paste in azure blob storage name* -> 404 error

I've tried all the vartiations of the URL I can think of as well.

[v-yadongf-msft]

Hi @picknotts ,

Currently max size of a block blob is approx. 4.75 TB, storing MB-sized data in a block blob, which should not cause Azure Blob service return 404 when you access the blob. 404 error indicates that the specified blob does not exist. Blob name is case-sensitive, please make sure the (blob name) you provided indeed exists in your container.filename

For more information, please refer to:

c# - Azure blob storage returns 404 with some files - Stack Overflow

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.