Forum Discussion
TSV
Hi, Need some guidance please. I have a .tsv files on my local drive which I am struggling to import. Cannot seem to find the correct method to import it. How can I import .tsv files into PBI...
I made a tsv file from Excel (save as Text (tab delimited), then change extension to TSV), and was able to ingest that into Power BI. Maybe the file format is different than the files you are dealing with, but try to connect with CSV/TXT connector, and in the file picker change it to all file types. In the next screen, you can choose tab delimited and ingest the data. Alternatively, you can change the extension of your tsv to txt and use same connector.
Sorry if you've already tried that, but thought I'd chime in.
Regards,
Pat