Forum Discussion

tuandph's avatar
tuandph
Regular Visitor
9 years ago
Solved

Performance Power BI on-premise with SSAS Multidimensional 1TB

I have an SSAS Cube about 1TB data in Multidimensional mode and I wonder that this is a big Cube.

Is there any performance issue for Power BI on-premise if I use Live Connection to get data from that SSAS Cube? Please advise me.

 

Thank you.

Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    tuandph,

     

    Performance wise Import would be quicker if dataset is small since there would be caching.

     

    But if dataset is large and you've used import you may have performance issue plus longer times for data refresh. DirectQuery would take away the need of data refresh but that means there maybe bit of delay in getting data for visuals as queries would be sent to on-premise data source. For example when you apply a filter queries would be sent to on-premise data source.

     

    So I don't think there will have performance issue on Power BI, there might be have performance issue on your cube which have 1 TB data.

     

    Regards,

    Charlie Liao

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    tuandph,

     

    Performance wise Import would be quicker if dataset is small since there would be caching.

     

    But if dataset is large and you've used import you may have performance issue plus longer times for data refresh. DirectQuery would take away the need of data refresh but that means there maybe bit of delay in getting data for visuals as queries would be sent to on-premise data source. For example when you apply a filter queries would be sent to on-premise data source.

     

    So I don't think there will have performance issue on Power BI, there might be have performance issue on your cube which have 1 TB data.

     

    Regards,

    Charlie Liao