I think there's an error in a unit quiz

Question

In unit 7 of Optimize a model for performance in Power BI, it asks :

Which of the following statements about relationships in Power BI Desktop is true?
• Relationships can only be created between columns that contain the same data type.
• Relationships can only be created between tables that contain the same number of rows.
• Relationships can be created between tables that contain different types of data.

Both the first and last seem true to me, but the answer says the first is false.

Here's a direct quote from the tutorial:

"During development, you are creating and editing relationships in your model, so when you are building new relationships in your model, regardless of what cardinality you have chosen, always ensure that both of the columns that you are using to participate in a relationship are sharing the same data type. Your model will never work if you try to build a relationship between two columns, where one column has a text data type and another column has an integer data type."

Answer 1

Hi ash p,

Thank you for reaching out to us on the Microsoft Q&A forum.

The article referenced says they should be the same data type but does not say they must be the same. It goes on to explain the implications if the data types are different. The knowledge check being challenged is asking what is true, not what is suggested.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer & Upvote so that it would be helpful to community members.

Thank you.