Which Power BI layer is responsible for extracting and transforming data before it enters the model?
- A DAX
- B Power Query (M)
- C The report canvas
- D Row-level security
Answer
Power Query (M)
Transformation should happen as far upstream as possible: in the source database first, then Power Query, and only in DAX when the calculation depends on user interaction.





