Forum Discussion
How to read Tsv file from Azure Data Lake into Power BI
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 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,
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"?
2 Replies
Eric_ZhangMicrosoft Employee
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,
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"?
Thank you Eric_Zhang
