Showing results for 
Search instead for 
Did you mean: 
jdb Frequent Visitor
Frequent Visitor

using SQL views instead of Power BI transformations and relationships?

OK, I'm probably thinking about this the wrong way since I'm coming from a SQL background.


But for the first two sections of the course, I would implement these functions (transformations and relationships) as views in SQL, and then build Power BI reports off the views.


Advantages I see are SQL views are easier for me to build and debug, may perform better since the work's done on the server, and offer better reuse across other applications.


Is there anything fundamentally wrong with this approach?