In some scenarios like this you need to grant SQL managed identity Storage Blob Data Contributor role on the Storage account, for doing this you need to create the storage account first, then from the left blade choose “Access Control (IAM)” and “Add role assignment” like the below screenshot. From