In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The transformations will perform better if they can be converted to a native query, especially a single native query for all transformations.
However, this is just a starting point for the optimizations. Sometimes, native queries for the transformations are not enough.
Test Environment
This will be the starting point:
An Azure SQL Database using the sample AdventureWorskLT You need to execute the script Make_big_adventure.SQL adapted for the AdventureWorksLT. You can find it on https://github.com/DennesTorres/BigAdventureAndQSHints/blob/main/make_big_adventureLT.sql Recommendation: The Azure SQL Database is