Bhavik Merchant on 27 Sep 2015 13:58:54
When importing a CSV file, we need the ability to allow handle text values with commas in them. This is usually done with double quotes or some other text qualifier. This works automatically in the PowerPivot data import, but not in Power BI or Power Query
- Comments (5)
RE: CSV import needs to handle text qualifiers
This is pretty basic functionality for importing large CSV files.Workaround is to import as a single column Fixed Width and then use Split Column which does have this functionality.
RE: CSV import needs to handle text qualifiers
Unfortunately with importing some tools require all columns with text, dates, empty values for it to be between double quotes. Even Excel understands this, but I don't want to add another (manual) step between the export from PowerBI and importing it in another application.
RE: CSV import needs to handle text qualifiers
Just ran into this issue on a CSV file produced by PowerShell's Export-CSV, which double-quotes all columns. Any workarounds in lieu of more robust handling?
RE: CSV import needs to handle text qualifiers
Competitive products simply read CSV data correctly. With PowerBI, it requires every value to be quoted or none to be quoted. It does not recognize 'minimal' quoting. PowerBI does not handle escaped quotes. Please handle escaped quotes or commas properly.
RE: CSV import needs to handle text qualifiers
You could load the csv as plain text and then do the transformations as desired