Set Azure Container Access Level to Private with exceptions

Hello everybody!

Me and my team were wondering if it's possible for a Storage Account to have the Access Level of its containers set to "Private" and at the same time provide access to them to some users or identities, as if they had public access.

What we want to do is to access this container through our Azure Synapse pipeline and create views and maybe external tables. However, if we don't set the access level to "Container" (i.e., "Public") we won't be able to run our pipeline. 

Should anyone know how to do a workaround please let us know.

Thanks in advance for your time!