Status:
Investigating
CSV Delimiter while Quote
Hello Team, I am trying to split the csv file with the | demiliter and the delimiter is also available in the " " which i do not want to split. As usual i have used Quote character but it is no...
Hi Anonymous ,
Power BI should ideally handle CSV files correctly, respecting the quote characters and not splitting data within quotes even when the delimiter is present.
When loading the CSV file into Power BI, ensure that you’ve set the correct delimiter (|) and quote character (").
If the file size is causing the issue, try splitting the file into smaller chunks and then load them into Power BI.
As mentioned earlier, you could preprocess the data to temporarily replace the | characters within quotes with a unique character sequence that is not present elsewhere in the data. After loading the data into Power BI, you can replace this unique character sequence back to |.
Best regards.
Community Support Team_Caitlyn