I've followed what seemed to be a very straight forward setup to configure azure to transform my web.config but it isn't working as I expect. Here's what my web.config looks like locally.
Here's what my appSettings section looks like in the Azure Portal. By the way, this is a Dev slot and I'm deploying from Visual Studio Team Services.
Here's the outcome, my web.config on azure. I expect the web.config to have my new connection string, but as you can see, it does not. It wouldn't bother me too much if it just wasn't showing here, but the site is broken, so I assume, the transform isn't happening at all.
P.S. I've also tried this in a similar fashion with appSettings with the same result