Reply
iamsaanvi
Regular Visitor

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,

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft 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,


@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"?

Capture.PNG

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft 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,


@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"?

Capture.PNG

Thank you @Eric_Zhang

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)