There is a difference between double clicking the CSV file vs importing from within. Importing via Get Data > CSV will bring up PowerQuery which only made a copy of the source file and allows me to modify the data without affecting the original file. If I made a mistake after transforming, I can go back to PowerQuery (without importing again) and undo the step then adjust the modifications. That is the beauty of PowerQuery. Even in the wizard, it does allow me to set the data type of the columns before opening. Users generally skip that step ahead and get down to the data.
Problem with importing is that laypeople are not familiar with PowerQuery and it can be overwhelming for lot of users.
It didn't make it less shitty. The problem is on the between the keyboard and the chair. If users take the time to be familiar with the wizard and PowerQuery, a lot of miscorrection would be avoid in the first place.
Oh I see. I definitely don't want to go through all these hoops. If it doesn't open it properly on click, it's only a failure which needs to be corrected by hand - be it with PowerQuery or whatever. And getting familiar with a shitty workaround doesn't make it less shitty or less workaround.
Problem with importing is that laypeople are not familiar with PowerQuery and it can be overwhelming for lot of users.
It didn't make it less shitty. The problem is on the between the keyboard and the chair. If users take the time to be familiar with the wizard and PowerQuery, a lot of miscorrection would be avoid in the first place.