Bamakus Montreuil on 24 Apr 2024 11:50:32
Promote Composite models V2 ( Aka direct query to semantic models) strong ADOPTION
But there are still 3 or 4 huge & "sad" limitations
- potential issues using a calculation group on the remote model over mixed "retail type" KPIs
- security leaks because RLS setup on a remote table is not filtered a local table
- performances issues on DAX queries (rendering on the composite model)
- related() DAX function not possible to the 1 remote table
Fix above 3 issues relative to limited relationships between tables ( or 2 different source groups)
or
Forbid the 2 uses cases possibility on the local model <== related() issue gets a warning
(avoid remote calculation group access + avoid local table relationships with a remote table under RLS)
or display warnings messages on the local model <== related() issue get a warning