Direct connection to Storage Accounts via Azure automation is not possible without using a hybrid worker.
Currently, we cannot use the Connections strings to a storage account to connect to the Azure file share on azure automation. To access the blob/file share, we need to set up a hybrid worker and from there we can do whatever we want
This shouldn't be the case, we should be able to establish direct connection to the file share.

Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.