Data Type of Relationships in Power BI

Vanaja V 20 Reputation points
2024-06-16T14:07:32.0066667+00:00

Hi,

In the the Knowledge Check of Optimize a model for performance in Power BI, it is said that 'relationships can be created between columns that contain different data types in Power BI Desktop.'
KnowledgeCheck https://learn.microsoft.com/en-us/training/modules/optimize-model-power-bi/7-check
However, the article below says 'The data type for both the "from" and "to' column of the relationship should be the same.' https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#data-types-of-columns
DataType Can you please clarify this?

Thanks,

Vanaja

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.
210 questions
{count} votes

Accepted answer
  1. Syed Saleem Peera 2,035 Reputation points Microsoft Vendor
    2024-06-20T08:45:58.5233333+00:00

    Hi Vanaja V,

    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.

    Thank you.


0 additional answers

Sort by: Most helpful