Forum Discussion
Anonymous
6 years agoNot applicable
No Text Delimiter Option While Importing Text/CSV Data in Power Query
Hello, I am trying to import Text/CSV file in Power Query, but while doing that I don't have an option to chose delimiter in the import window as it is shown in the following post response: htt...
Ajinkya369
6 years agoResolver III
Import CSV
Hey Anonymous,
You just need to click on new source - > text/csv and then locate to your file.
Then import screen will be opened where you can select the delimiter of your choice.
You can find the Csv.Document in the source step.
You will get the CSV.document in the source stepe
There is no presetting for this. Please follow the above steps and let me know whether its working for you or not.
If your problem is solved then please accept this as solution.
Thank you
- Anonymous6 years agoNot applicable
Thank you, however it doesn't help. I tried to make my problem more clear with some pictures, please have a look.