I have two (DirectQuery) detail tables, with an (imported) aggregation table based on them, but: when attempting to configure aggregation management in PowerBI, it throws this error:
"Detail column cannot be aggregated to one or more Group By columns using strong relationships."
The problem is that this error throws even when I modify (or at least I think I modify) every table related to the detail tables so that they should not be strongly-related to anything else in the model. The only table that appears like it could even possibly be strongly-related to either detail table is dim_Tenant, but changing its storage mode to Import (which I would expect to change its relationships to the detail tables to weak) has no effect on the error:
So actually, never mind on this problem for now... while I'm fairly certain that it should be possible to link an agg table to multiple DirectQuery detail tables, I suspect that the way I was trying to do it here (i.e. no relationship between the detail tables) was the problem. I'm going to try some experiments with cleaner data warehouse data (e.g. Worldwide Importing) -- where the data lends itself to a direct relationship between detail tables -- and see if I'm right.
Hi @LastThird
could you share your sample file after removing sensitive information? I will test it later.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
