Transformations in SQL rather than Power BI but using Direct Query

Hi everyone Up until recently I've been pulling data from our SQL database into Power BI via Direct Query Mode and then doing all my Transformations from within Power BI. However, I've read tha...