Creating a Semantic Model

Now that we have access to a Power BI license, we can explore the true power of semantic models. In this exercise, we’ll create a semantic model and define a relationship between two tables in our lakehouse.

Data type compatibility: When you create a relationship, the two columns (e.g. the key in each table) must have the same data type (e.g. both text/String or both whole number/Int64). If you see an error like "data types of Direct Lake relationship … are incompatible," ensure both columns match: either change the column type in your data (e.g. in the lakehouse) so both are the same type, or choose a different pair of columns that already match.