Forum Discussion
When connecting to a csv source, data shows wrongly encoded
Hi simmi21 ,
When testing with the sample data you have provided, seems like it works fine in Power BI:
The .txt file also works:
Perhaps you can re-create a txt file with data to try to connect it in Power BI to check, then change to .csv file to re-connect to check it again.
If the data just show one column in the navigator, you can click transform data and split by delimiter as @ AlexisOlson manually, use the first row as the header.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes, now its is unencoded but all in one column, the delimtter (which in my case is a semicolon ) is not working. This is how it is coming now :
You should be able to split the column in the query editor even if you load it as a single column.