Forum Discussion

eric98's avatar
eric98
Helper II
4 years ago

DIrectQurey Mode

Hello guys, 

I'm currently facing a problem and I need your help.

I'm working with an Oracle Database and I have a lot of tables. One of this table have more than 4 millions row and It's very difficult to work with this dataset.

I try to create an agregation table to increase the performance but I'm always getting this error : Aggregation tables cannot be on the filtering side in relationships with other tables that are not aggregation tables.

 

Does anyone faced this type of issue before ?

 

Note that I have a Power BI Pro license.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    eric98 , Are you trying to create an aggregate table for dimension, which means for 1 side of the table?

    Error seems like that

  • eric98's avatar
    eric98
    Helper II
    4 years ago

    Anonymous Yes that's it. I think that it's impossible to that.

    • eric98's avatar
      eric98
      Helper II
      4 years ago

      This is an image which represent my data model