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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Cherry,

    I also have tsv files. I'd like to use your offer to convert them. Please publish instructions for how to accomplish this task.

  • 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.