Basic Settings PowerBI
If you are using PowerBI as your tool of choice, please apply the following recommended settings.
1. Install PowerBI...
b. In All apps, search for PowerBI and download the desktop version.
2. For each new PowerBI file (.pbix) you must reset these settings:
Deselect the Autodetect new relationships after data is loaded and Auto date/time check boxes. These slow down data loading and are not required.