As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we have an option to avoid this limit!