Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I understand that you would like to configure private access between an Azure automation account and Storage Account.
- Please note that Private EndPoint can only be used to provide inbound traffic (connect to) to a PaaS Service
- It cannot provide outbound access from the PaaS Service.
- Meaning, the PaaS service should rely on it's Public IP or list of outbound Public IPs (for some PaaS) to make external calls.
Now, in your scenario, I see you would like to use your Automation account to connect to a Private IP (Private IP of the Storage Account Private EndPoint)
- In this case, you must consider using Automation Hybrid Runbook Worker on a VM in the same VNET as the Private EndPoint
- Then, this VM will be able to access the private IP of the torage Account's Private EndPoint
More details can be found here.
Thanks,
Kapil