Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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,
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 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"?