Hello @swee ,
Thank you for your query.

If your storage account is private, you would need to establish a route to that storage account so you can read data.
This is because if your storage is private, your storage account will block access to the public internet.

This GitHub repo contains instructions on how to set up your network configuration based on your requirements.

Once you configure the network configuration I am confident you will be able to read data.

Thank you