Check Your Knowledge: Model data with Power BI / Optimize a model for performance in Power BI

Edison, Samuel 0 Reputation points
2024-06-28T12:27:13.32+00:00

https://learn.microsoft.com/en-us/training/modules/optimize-model-power-bi/4-reduce-cardinality

https://learn.microsoft.com/en-us/training/modules/optimize-model-power-bi/7-check

Question 3 in unit 7 asks:

Which of the following statements about relationships in Power BI Desktop is true?

Answers:

Relationships can only be created between columns that contain the same data type.

Relationships can be created between tables that contain different types of data.

The "correct" answer is Relationships can be created between tables that contain different types of data.

However, in unit 4 it says:

"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."

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
211 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kiran P 1,805 Reputation points Microsoft Vendor
    2024-06-28T14:42:32.1833333+00:00

    Hi Edison, Samuel,

    Thanks for reaching out to us on 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 so that it would be helpful to community members.