Forum Discussion
Solved
Data Modelling in MS SQL vs in Power BI/DAX
Hi All - Our organization is moving our reporting from Excel over to Power BI. Our source data comes from various sources (Oracle Tables, MS SQL Tables, CSV files, Analysis cubes). As such, i...
Most of my reading points towards using SQL to create views that are then fed to PowerBI where you create the model (relationships and measures). This allows good control from an IT governance perspective. Take a look at this article from the team at SQLBI.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/
Most of my reading points towards using SQL to create views that are then fed to PowerBI where you create the model (relationships and measures). This allows good control from an IT governance perspective. Take a look at this article from the team at SQLBI.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/