cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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?

 

Thank you

5 REPLIES 5
Highlighted
Resident Rockstar
Resident Rockstar

Re: TSV

Hi @andrezhar,

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper V
Helper V

Re: TSV

TSV stands for Tab Separated Values. TSV files are used for raw data and can be imported into and exported from spreadsheet software. TSV files are essentially text files, and the raw data can be viewed by text editors, though they are often used when moving raw data between spreadsheets

https://stackoverflow.com/questions/46893638/how-to-read-tsv-file-from-azure-data-lake-into-power-bi
Highlighted
New Member

Re: TSV

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.

Highlighted
Advocate II
Advocate II

Re: TSV

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.

Highlighted
Community Champion
Community Champion

Re: TSV

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

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors