Skip to main content

    Power BI

    Needs Votes

    Warning or Error when creating a relationship between Date and Date/Time Fields

    Vote (1) Share
    Bobby Lansing's profile image

    Bobby Lansing on 14 May 2021 18:53:58

    When creating a relationship between Date and Date/Time fields Power BI should display a warning or error, because the functionality works as follows:

    - Date/Time with 1/1/2021 12:00:00AM matches with 1/1/2021
    - Date/Time with 1/1/2021 02:35:00PM does not match with 1/1/2021

    This has lead to multiple hours of troubleshooting only to realize that I need to change the Date/Time to a Date in Power Query.