I have an Azure Static Web App with a Managed Azure Function, that connects to SQL server using entity framework 8.0. I am trying to read the connection string from a key vault secret. In the development environment everything works as expected. But when I deploy the Static Web App, the managed azure function can’t access the key vault. If I hardcode the connection string everything works.

I granted access to the Static Web App to the key vault, but it looks like the managed Azure function is not inheriting the access. The azure function is in a subfolder of the Static Web App. Any idea what I am missing?