Incomplete data from TSV files in Power BI

[Rajamohan]

I am not able to completely import data from .tsv files into PowerBI/Power query. The .tsv files are not very big (~75 MB). However, I get no such issues while importing the data into PowerPivot.

Does anyone else have the same issue?

Is anyone aware of a fix/workaround for this? Thanks in advance`

[curth]

Can you provide more detail? Is there, for instance, an error message?

[Rajamohan]

I don't have any error message. only that, when I compare the data, it's not completely loaded in PowerBI but is fine in Power pivot.

I see similar issue with some other .tsv/.txt files with file sizes more than 50MB when imported from from Cosmos.

[smnthdcstr]

where you able to solve this? I'm having the same issue