PowerBI won't open tsv files anymore

[jader3rd]

I output tab seperated files with a .tsv extension from Azure Data Lake Storage. I used to be able to open them from Power BI Desktop. But now Desktop has locked down it's text file dialog to only allow txt, csv, prn. This is annoying, because I don't want to take the extra step of modifying the file extension just for Power BI.

[vanessafvg]

thats odd because i was able to change it all to all files

see if you can do it this way by copying and pasting into a blank query in power  query 

change it to use your file name

let
Source = Csv.Document(File.Contents("filename"),[Delimiter="#(tab)", Encoding=1252])
in
Source

[jader3rd]

Here's my version Version: 2.126.553.0 64-bit (February 2024).

[vanessafvg]

i am little confused the last published version of power bi thats available is december.

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update?tabs=powerbi-desktop

do you have access to a later version?

[vanessafvg]

when you say it used to allow that,what method were you using before?

[jader3rd]

Get Data, Select Text/Csv, this would open an File Explorer dialog which defaulted to *.txt, *.csv, *.prn, but there was an option to change that All Files. It looks like Power BI took away the All Files option.