Relationship Issues With DateTime Data Types in Power BI

Video by: Reid Havens

Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.

RELATED CONTENT 🔗

PQ Vs. DAX Data Types

Posted on April 13, 2021 and filed under Power BI, Beginner, Data Modeling, Power Query.