Power Bi - Inefficient Backend Development ?

Hi Anonymous - yes and no.  Data should be transformed "as far upstream as possible and as far downstream as necessary" (Roche's Maxim).  But the key here is "transformations".  This should not include "Data Analysis".  Power BI using DAX provides a better experience for Data Analysis.  To understand this you need to see the SQL Queries that are dynamically created by the DAX engine to extract data from Star Schema.  By simple drag and drop, slicer selections, Power BI uses DAX to generate thousands of lines of SQL.  So when someone say an SQL developer can solve the business requirement, I laugh.  Too many times, I have seen SQL Developer who does not understand DAX hard-coding TOPN, PIVOT, UNPIVOT, CASE WHEN AGGREGATIONS and JOINS when SSAS Tabular, Power BI and DAX would have more flexibility.