Forum Discussion

Oleg_F's avatar
Oleg_F
Frequent Visitor
6 years ago
Solved

Aggregation table in data model

Hi. Is it possible to create aggregation table (in data model), to improve speed, if all tables, also fact table(source), are in import mode in Power BI, or fact table must be only in direct query m...
Need Help
  • Oleg_F's avatar
    Oleg_F
    6 years ago

    After a long search in the internet and a lot of videos, I have only one conclusion - aggregation tables are used to enhance performance while you are working with DirectQuery mode.
    The answer is:
    - No, fact table(source) must be in DirectQuery mode.


    Thanks everyone for help.