How to read Tsv file from Azure Data Lake into Power BI

[iamsaanvi]

tried to read a tsv file from an Azure data Lake, but power BI keep telling that file format is not recognize, is there a way to specify the delimiter type (like this \t)?

Thank you,

[Eric_Zhang · Accepted solution]

---

@iamsaanvi wrote:

tried to read a tsv file from an Azure data Lake, but power BI keep telling that file format is not recognize, is there a way to specify the delimiter type (like this \t)?

Thank you,

---

@iamsaanvi

Per my test, the file with tsv extension can be recogonized, the tab delimiter is also no issue. I don't have a Azure data lake source at hand, do you get data from "Azure data lake store"?

[iamsaanvi]

Thank you @Eric_Zhang