Transformations in DirectQuery mode need to be executed with each query to the source system, and they should be converted into a query native to the source system.