star schema - inner join

[Anonymous]

hi all,

i create a model base star schema. the join between fact and dim is (many to one = single).

on the direct query syntax, the join is "left join" not "inner join " .

is it possible to force the select according to inner join?

thanks.

[v-frfei-msft]

Hi @Anonymous ,

Hope this article can help you.

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/