Manage funky number formats importing csv file

Hi Anonymous ,

When you import your CSV file, Power Query will try and 'guess' the data type based on the first X number of rows (specified in the CSV import dialog). This will create a 'Changed Types' step in your APPLIED STEPS list on the right in PQ. something like this:

You can delete this step to revert your query to the raw data imported.

You can change/prevent this behaviour altogether by going to File > Options & Settings and adjusting the following:

To apply globally to all reports:

To apply to only current report:

Pete