Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
Proud to be a Super User!
Here's my version Version: 2.126.553.0 64-bit (February 2024).
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?
Proud to be a Super User!
when you say it used to allow that,what method were you using before?
Proud to be a Super User!
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |