Unpacking the Auto date/time option in Power BI : What you need to know

We all work with dates, but are we aware of the impact that a load option can have on our report?

In this video I give some examples in order to demonstrate how the Auto date/time data load option behaves and how this could impact our Power BI desktop file size.

Timestamps:
0:39 - overview of the dataset and default date columns behavior
1:59 - DAX studio overview
6:17 - Problem of the 31/12/2999 date
9:00 - Best (that may be not so best) practice - create a separate date table
14:30 - Mark date as date table
15:41 - Disable the Auto date/time option

[shreekantgosavi]

Please upload more videos, you have amazing talent

[marcorozzano]

There's not a week that goes by where I have to inform new report developers to disable that feature and *then* use a dedicated date table instead.