Connecting to Warehouse in Fabric from private Fabric tenant

Hi all, So I have my generic ingestion pipeline that uses a warehouse with stored procedures for logging, watermarking and that kind of stuff. Our pipeline has multiple stored procedure steps in it to do this. We want to make our Fabric tenant private, but when doing this, our pipeline fails on these warehouse stored procedure steps. After investigation we concluded that, even though the pipeline and warehouse are in the same workspace and therefore same private network, the connection goes through the public internet. We tried multiple routes but haven't been able to solve this: We tried an E