We had a successfully deploying pipeline using Azure Connection Type Azure Classic which we started getting this error on ("The storage account 'xxxxx' was not found"). It was resolved by changing the Connection Type to Azure Resource Manager.
Azure Classic
Azure Resource Manager