Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I often give my Tab Separated Values files a TSV extension. Fabric doesn't seem to want to allow me to open the file:
Should I stop giving my Tab Separated Values files a TSV extension and instead give them a CSV extension?
Interestingly, I renamed the file mentioned above from a TSV extention to have a CSV extention. Then when I tried to load it, the Separator Input Box would not let me enter a tab character:
So now, I technically have two questions.
I guess the workaround for both questions right now is to end all files with the CSV extension and use the | character to separate values. The files are comming to me in CSV format, but I guess I can use Excel to quicky convert them to "CSV" using the | as separator.