Cannot parse tsv with special characters

raghun · ‎06-20-2018

I have a tsv file with the following line and PowerBI desktop is failing to parse it putting all fields in the first column. I have set the encoding to utf-8 (65001)

ITS Comércio, Representações e Serviços em Tecnol e9e4126b-8112-4ca6-ab0e-2474c2948ea8 e9e4126b-8112-4ca6-ab0e-2474c2948ea8 10 0 0 0 0 New e9e4126b-8112-4ca6-ab0e-2474c2948ea8 9 0 0 0 0 New

Any idea how I can fix this?

Anonymous · ‎06-20-2018

@raghun,

What is the result would you like to get based on the sample data in Power BI Desktop? What is the original format of the above sample data in tsv ?

Regards,
Lydia