Forum Discussion
Carriage return in Comment column is causing columns after comments to be empty
I am working with a dataflow
If I test the data using a specific record by filtering at the beginning of the process just after importing the data from csv and promoting headers, in Power Query editor I see this
But in the File itsself looks like this
Note that its cut the comment at the carriage return and not brought though the other information for the other columns
When I check the comment in Notepad ++ it cuts off where the comment is added to a new line.
Is there aything I can do in Power Query Editor to fix this problem?
I can see that Power BI may cut off the Comment itsself but to lose all the data after in the other columns is really odd
I tried the solution in https://community.powerbi.com/t5/Desktop/Replace-carriage-return-in-dataset/td-p/24900 right after importing csv but it hasn't made a difference
The step where the data is loaded looks like this
- Anonymous6 years ago
Hi DebbieE ,
Please try to update the source code as below and check if it can display normally:
Csv.Document(#"Demo table csv_https://Customer sharepoint com/sites/DataStore/Shared Documents/General/", [Delimiter = ",", Columns = 13, Encoding = 1252, QuoteStyle=QuoteStyle.Csv]) Best Regards
Rena
4 Replies
- amitchandakSuper User
ImkeF @ can you help on this
- AnonymousNot applicable
Hi DebbieE ,
Please try to update the source code as below and check if it can display normally:
Csv.Document(#"Demo table csv_https://Customer sharepoint com/sites/DataStore/Shared Documents/General/", [Delimiter = ",", Columns = 13, Encoding = 1252, QuoteStyle=QuoteStyle.Csv]) Best Regards
Rena
- AnonymousNot applicable
- DebbieECommunity Champion
Yes you can mark this as resolved
It turned out to be an issue before it even hit Power BI and had to be dealt with at source
Debbie