Forum Discussion
Solved
How to import multiple text files with quotation mark inside, from a folder
Hi, I have a folder where everyday new text files are saved. I setup a powerquery, which imports all the files content in excel with filename in 1st column and the text rows in 2nd column. Ever...
It seems I found a solution.
https://community.powerbi.com/t5/Desktop/ignoring-Line-breaks-within-quotes-while-importing-folder/m-p/234540After opening the actual query, click "Transform Sample File", then click gear button on source (under applied steps) on right pane, then select open file as "Text file" from drop down.
This resolved the issue of " quotation.
It seems I found a solution.
https://community.powerbi.com/t5/Desktop/ignoring-Line-breaks-within-quotes-while-importing-folder/m-p/234540
After opening the actual query, click "Transform Sample File", then click gear button on source (under applied steps) on right pane, then select open file as "Text file" from drop down.
This resolved the issue of " quotation.