SSAS vs Power BI

@Anu It can be better as it read 8M rows at a time by default and decides the sorting option by each segment, Larger segment means Storage Engine won’t have to spend too much time in joining smaller data caches and this can speed up the process. But SSAS is not just about loading data and expecting performance benefits, it is a complex tool so you need to spend more efforts in learning than you have spent in PBI.

Here is a property which you can disable and can help you out of the box: https://blog.crossjoin.co.uk/2018/07/02/isavailableinmdx-ssas-tabular/

2 Likes