Report Perfomance slow cause by SSAS partitions ?
Hello All, Is that report slowly cause by I used SSAS partitions ? And also, I do a lot of testing in SSAS partitions like below table shows CPU Core Partition Number Report time (AVG) Granularity 8 1 8 sec 3 years 202008~202208 8 2 20 sec 202008~2021 202201~202208 8 3 18 sec 202008~202012 202101~202112 202201~202208 There is some detail in my test 1. Order topic have order header and order body two Fact table 2. there 6 million in header, 10 million in body 3. partition only do in header table 4. I used 2019 SSAS 1500 level project 5. I used DAX Studio to get report time In MS doc partition limits said: Query performance can be negatively affected when the storage engine has to scan an excessive number of segments. But I only split 2 or 3 segment. and can anyone explain why when I used partition feature then the report speed slowly 2 times? Thanks!