Aggregate Table in Import Mode

[SumanBindu]

My PBI report has all its tables in import mode, with the fact table being really huge. Can an aggregation table be helpful here to improve performance by a bit?

[AxiomaticOne]

@SumanBindu yes it absolutely can, check this out and the prior articles in this series for potentially easier methods. https://dax.tips/2019/11/15/creative-aggs-part-vi-shadow-models/

[aj1973]

Hi @SumanBindu 

The answer is No. The solution would be better to use DQ connection on the Fact table.