It's not the octane of the fuel that provides the power. The power in each drop of petrol is roughly the same, regardless of the octane.
The octane rating is only important because you don't want the fuel to pre-ignite. A fuel with a low octane is more likely to pre-ignite in a high compression engine.
A high compression ratio engine
needs high octane fuel or it will be damaged. All others can run on high or low octane.
If your compression ratio is less than 10.5:1, just use which ever pump you like.
BMW Z3 Specifications
It looks like the M, the 2.0 and the 2.2 would benefit from high octane, the rest just need Asda's finest.