PL-300

Study mode — explanations shown

1

Model the data

hard

You are reviewing a Power BI model definition in JSON. The Sales table contains a ProductID column but the Product table does not have a ProductID column; instead it has a ProductID column with dataType string. What issue will occur when you try to create a relationship?

Exhibit

Refer to the exhibit.

```
{
  "tables": [
    {
      "name": "Sales",
      "columns": [
        {
          "name": "OrderDate",
          "dataType": "dateTime"
        },
        {
          "name": "ProductID",
          "dataType": "int64"
        },
        {
          "name": "Quantity",
          "dataType": "int64"
        },
        {
          "name": "Amount",
          "dataType": "double"
        }
      ]
    },
    {
      "name": "Product",
      "columns": [
        {
          "name": "ProductID",
          "dataType": "int64"
        },
        {
          "name": "ProductName",
          "dataType": "string"
        }
      ]
    }
  ],
  "relationships": [
    {
      "fromTable": "Sales",
      "fromColumn": "ProductID",
      "toTable": "Product",
      "toColumn": "ProductID"
    }
  ]
}
```
0 of 90 answered