Theres a confusion in the check knowledge question considering the traing text says : Your model wont 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.

Hi Fola Animashaun , 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. While it recommends matching data types for consistency and accuracy, it acknowledges that different data types can be used but may lead to unexpected behavior or errors. Understanding the potential consequences of using different data types is key to making informed decisions in data management. 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. Thank you.

Misleading text in training

Accepted answer

Syed Saleem Peera 7,470 Reputation points Microsoft Vendor

2024-07-26T06:08:19.2166667+00:00

Hi Fola Animashaun,

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.

While it recommends matching data types for consistency and accuracy, it acknowledges that different data types can be used but may lead to unexpected behavior or errors. Understanding the potential consequences of using different data types is key to making informed decisions in data management.

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.

Thank you.
Please sign in to rate this answer.
Fola Animashaun 20 Reputation points

2024-07-26T09:07:19.07+00:00

Hi, Thanks for the response, i guess the confusion comes from never work which implies that it is a must for the data types to match

Syed Saleem Peera 7,470 Reputation points Microsoft Vendor

2024-07-29T03:28:36.1966667+00:00

Hi Fola Animashaun,

Thank you for your follow-up question. I understand the confusion around the statement "never work.

To clarify:

Matching Data Types: While Power BI does allow the creation of relationships between columns with different data types, the training text's use of "never work" is likely emphasizing best practices. Matching data types ensures that relationships work consistently and accurately. However, the platform can still create relationships with different data types, though it may lead to issues or unexpected behavior.

Practical Consideration: In practice, mismatched data types can cause problems such as failed joins or incorrect data interpretations. Therefore, it's recommended to align data types where possible. The key point is that relationships can technically be established, but for reliable results, matching data types is best.

Knowledge Check Context: The knowledge check is focusing on what is technically possible, not just recommended practices. Therefore, the correct answer acknowledges that relationships can be created with different data types, even if it's not ideal.

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.

Thank you.

Syed Saleem Peera 7,470 Reputation points Microsoft Vendor

2024-07-29T06:04:26.5333333+00:00

Hi Fola Animashaun,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

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

Thank you.

Syed Saleem Peera 7,470 Reputation points Microsoft Vendor

2024-07-29T14:02:54.3633333+00:00

Hi Fola Animashaun,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Misleading text in training

0 additional answers

Your answer