Skip to main content

Power BI

New

Improve direct query to semantic model robustness

Vote (2) Share
Bamakus Montreuil's profile image

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