Forum Discussion
SSAS architecture for Power BI
Hello anandav ,
this depends on many factors but the following applies:
A materialized view (apparently you come from the Oracle world, because in SQL Server the views are called Indexed Views and are usually worthless) takes load off the RDBMS and is often used as a performance improvement. You just have to make sure that the refresh interval is correct.
Loading into the SSAS Cube is always better and faster than a direct query. It also depends on whether you need the SSAS Cube at all. Please read this article.
In general, persisting data is always faster and better than direct access - no matter at what level in your architecture. But the problem is that it leads to data latency and you have to pay attention to the refresh intervals.
Maybe this Whitepaper is also of interest for you. Planning a Power BI Enterprise Deployment
BR,
Josef
Hello anandav ,
this depends on many factors but the following applies:
A materialized view (apparently you come from the Oracle world, because in SQL Server the views are called Indexed Views and are usually worthless) takes load off the RDBMS and is often used as a performance improvement. You just have to make sure that the refresh interval is correct.
Loading into the SSAS Cube is always better and faster than a direct query. It also depends on whether you need the SSAS Cube at all. Please read this article.
In general, persisting data is always faster and better than direct access - no matter at what level in your architecture. But the problem is that it leads to data latency and you have to pay attention to the refresh intervals.
Maybe this Whitepaper is also of interest for you. Planning a Power BI Enterprise Deployment
BR,
Josef