There are settings that are enabled by default to automate the process of data loading and modelling. They are disabled so that Power BI could be better understood in terms of what it is doing under the hood.
Changes made within Power BI desktop are listed below.
Changes made to these settings are applicable to current and newer .pbix files.
Changes made:
File → Options & Settings → Options → Preview Features
Certain preview features have been enabled to make full use of Power BI. There is no need to into the details here.
Changes made to these settings are applicable only to the current .pbix file and will be restored to default for other .pbix file.
Changes made:
File → Options & Settings → Options → Data Load → Time Intelligence
Auto date/time is disabled, so that column transformations can be done manually
File → Options & Settings → Options → Data Load → Relationships
Autodetect new relationships after data load is disabled, so that relationships between tables can be manually established
File → Options & Settings → Options → Regional Settings → Locale for Import
Set to English (US), so that datetime can be interpreted in US format
<aside> 💡
This is helpful in scenarios where system is configured to recognize dates in DD-MM-YYYY format, but the loaded data file contains dates in English (United States) format (MM-DD-YYYY)
</aside>