Forum Discussion

Helper II

10 years ago

how to force inner joins in direct query SQLs?

Hi, is it possible to force Power BI to create inner join queries instead of left outer join ones? I'm using SQL server with direct queries. thanks.

Community Champion

10 years ago

Here is a similar discussion with a possible solution:

M code gives you more flexibility around joins if you used Advanced View and edit the code directly if you can possibly join the tables pre-DAX.