You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.
Based on the given scenario, choose the correct set of options:
How do you combine the Customer & the Sales table?

What join kind would you perform? (Assume Sales is the right table)

What would you do to the original two queries?

You choose Merge Queries as New, Left Anti, & Disable Include in report refresh
Does the solution solve the problem?
Select 1 option(s):