The CURRENT FILE options must be set per the Power BI Desktop file and are particularly important when creating a new dataset:
- Disable the automatic column type and header detection for unstructured sources
- Disable all relationship options, including the import of relationships from data sources and the detection of new relationships after data is loaded
- Assuming a date dimension table is available to the dataset, disable the Auto Date/Time option
- For larger import datasets with many queries, disable the parallel loading of tables
- Click the OK button in the bottom-right corner of the Options dialog to apply these settings: