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.

Oleg_F's avatar
Oleg_F
Frequent Visitor
6 years ago

Greg_Deckler  clarify your answer:
a. Yes, it could be done if all tables are in import mode
b. Yes, fact table must be in direct query mode.


Thank You.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Aggregation tables require composite mode is my understanding. So they work when you have a mix of DirectQuery and import or all import.