Forum Discussion
powerbiexpert22
Impactful Individual
2 days agoReporting Views
what is the deciding factor for creating views in datawarehouse for reporting purpose, how i would know whether i should create view , as far as i know views are created for performance enahancement ...
krishnakanth240
Super User
2 days agoViews are created for abstraction and reusability. View is a stored query that runs at execution time, so it won't speed up. Create a view when you want to hide complex joins so multiple reports stay consistent. Also, Views are not limited to static calculations as they can include joins, aggregations and window functions as SQL runs each time so limitation is that they become inefficient over large datasets when queried repeatedly which is when a materialized view is the approach