Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

It seems that there is no direct connctor for TSV file in Power BI currently.

 

Here is a similar thread which provide a way help us import TSV file to power bi with Azure Data Lake Storage. 

 

In addition, if it is covenient, we could convert the tsv file to the txt, csv or excel which is supported in power bi currently as a workaround. 

 

Best Regards,

Cherry

Shawn_Eary's avatar
Shawn_Eary
Advocate V
6 years ago

Unfortunately, I had a rather large TSV file recently that didn't play all that nicely with certain programs so I had to exert notable troubleshooting effort to try to figure out why the said programs didn't like it.  It would have been nice if I could have just tried to import the TSV directly into Power BI without having to go through third party clients.   There still may have been issues with the TSV but skipping the intermediate step may have saved me some notable time.