DIrectQurey Mode

[eric98]

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.

[eric98]

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

[eric98]

This is an image which represent my data model

[amitchandak]

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

Error seems like that