The CData Power BI Connector for Salesloft supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT Actions.Type, ActionDetails.Instructions  FROM Actions INNER JOIN ActionDetails ON Actions.ActionDetailsId = ActionDetails.Id

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT Actions.Type, ActionDetails.Instructions  FROM Actions LEFT JOIN ActionDetails ON Actions.ActionDetailsId = ActionDetails.Id