Forum Discussion
jaryszek
Super User
Super UserManage aggregations multiple fact tables DirectLake over OneLake
Hi Guys, I want to use multiple fct_tables granularity like fct_table_daily, fct_table_monthly etc. I am using DirectLake over OneLake remote semantic model. 1. It is feasible to use this t...
Hello Jacek,
In aggregatinos tables, the user cannot force which table is used. If they select “Month” in a slicer, the engine may still query the daily table if the visual structure doesn’t match the aggregation definition.
Aggregations are designed for performance optimization, not user-driven logic. But in calculation groups there is explicit user control, the slicer dictates exactly which table is queried.
Best,
Anıl
jaryszekSuper User
Super Userthank you.
This is great answer!
anilelmastasiSuper User
Super UserYou are welcome Jacek, could you please accept as solution 🙂