- The M transformation functions supported in DirectQuery are limited by compatibility with the source system. The Query Editor will advise when a transformation is not supported in DirectQuery mode per Figure 32.
Figure 28: A warning in Query Editor that the IsEven M function is not supported in DirectQuery Mode
- Given this limitation and the additional complexity the M-based transforms would add to the solution, it's recommended to embed all the necessary logic and transforms in the source relational layer.
- Ideally, the base tables in the source database themselves would reflect these needs. ...