Why when i open some look very neat ?
Go to Solution.
Perhaps it was the way you extracted the CSV?
Can you look to see if you can extract it as a CSV delimited file?
Proud to be a Super User!
View solution in original post
Select Column A, go to 'Data' section on menu bar, click on text to columns button then follow the steps (choose the right delimiter)
Or you can open a blank spreadsheet --> 'Data' Section on Menu bar --> From Text/CSV button --> Follow rest of steps
I'm not entirely sure what the issue is here.
Are the rows that you refer to as 'neat' perhaps just shorter in terms of words/characters?
Is this causing any issues that you need to solve?
Usually when i open a CSV file , it look like below , but now mine look very messy. and i cannot delete the row for create sample file for testing.
I like your answer , will ask my IT to regenerate agin for me.
Let me know how you get on.
It just seems that the file does not have any delimiters which would allow Power BI to split out into columns.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.