It appears here that the issue is that the Azure Automation account, is unable to access the storage account due to network restrictions. When network access is limited to selected virtual networks and IP addresses, we need to add the public IP of the Automation Account to the storage account’s network settings.
If the Automation account has a static IP address, you can add this IP to the list of allowed IP addresses in the storage account’s network settings.
If the IP address is not static, you may need to allow the entire IP range for the Azure region where your Automation account is located. This not always ideal, but is a potential solution to the issue.