Thanks for the suggestion @Ashwin_DSA 

The call to the dbo.lakeflowDetectPlatform() function is the only one that fails - again on execute permission not being granted. But similar to the other function (dbo.lakeflowUtilityVersion_1_5), this isn't the cause of our problems. We have tested other connections without this particular privilege and that ingestion pipeline works just fine.