You Do Need power plug adapter while traveling from Dubai to Madeira.

Here is Why You Need An Adapter

The outlet and plug type used in Madeira are C and F and in Dubai is G. This is how they look like.

Dubai

In Dubai, outlets of type G are in use.

Type G

Madeira

In Madeira, outlets of type C and F are in use.

Type C

Type F