[Solved] You want to create a report combining sales data from SQL Server and customer feedback from a web API.... How can you combine these sources effectively? | Power BI

Power BI - Getting Data

You want to create a report combining sales data from SQL Server and customer feedback from a web API. The sales data uses product IDs, but the feedback uses product names. How can you combine these sources effectively?

AUse DAX to concatenate product ID and name into one column for joining

BCreate a lookup table mapping product IDs to product names and relate both tables to it

CImport only sales data and ignore feedback to avoid complexity

DDirectly join sales and feedback tables on product name in Power BI relationships

Step-by-Step Solution

Solution:

Step 1: Identify mismatch in join keys
Sales uses product IDs, feedback uses product names, so keys differ.
Step 2: Use a lookup table to unify keys
Creating a lookup table mapping IDs to names allows relating both tables properly.
Final Answer:
Create a lookup table mapping product IDs to product names and relate both tables to it -> Option B
Quick Check:
Use lookup table for mismatched keys [OK]

Quick Trick: Use lookup tables to unify different keys [OK]

Common Mistakes:

Trying to join on different key types directly
Ignoring feedback data
Using DAX to join columns incorrectly

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

More Power BI Quizzes

How can you combine these sources effectively?

Step 1: Identify mismatch in join keys

Step 2: Use a lookup table to unify keys

Final Answer:

Quick Check:

Want More Practice?