Forum Discussion
import files .dat
Thanks for the reply from KHANOS123 , please allow me to provide another insight:
Hi, KHANOS123
The method I have found to be most effective involves first saving the file as a .txt document, followed by importing it to the desktop:
1.Open the date file using Notepad, then save it as a .txt file.
2.Next, import the file on the desktop using the text/csv format.
3.Below is my sample data:
This is the final result, which I hope meets your requirements.
4.For further considerations regarding this method, please refer to:
Power Query Text/CSV connector - Power Query | Microsoft Learn
Please find the attached pbix relevant to the case.
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.