Thank You Martin.
Sorry for my late answer, I was off for a few days.
Concerning the first option, when I'm trying to select the SalesOrderItem as Array, I'm getting all the SalesOrderItem but only for the first "results". Thus, I'm not able to get a table with all the SalesOrderItems from all results and chain the two tables together with a key from "results".
Concerning the second option, how can I use the Data Flows Flatten Transformation withouth having a first copy of the data in Azure ?
Thank you very much for your precious help :)