SQL processing vs Query Folding

Hi Camill88 ,

As you and lbendlin  said, it is better to do all the conversions on the database side, which reduces the load in power bi. In real projects, a mixed approach is usually used. Initial heavy transformations (cleaning, grouping, calculations) are first performed on the server side using SQL to ensure that the data is in a manageable state before it reaches Power BI. Final adjustments and report-specific transformations are then performed using Power Query, which allows for flexibility and speed to make changes without having to go back to the database.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly