Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with Data transformation

I have exported data from. csv files to Power BI. One of the columns contains text values ( product description) and is getting dispersed across other columns. It looks the same in excel as well. Is ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Could you please upload one of your files to OneDrive, Google Drive or Dropbox then provide a link to it.  I don't knwo if the data you provided above is accurately formatted.  As I have to copy and paste it into a text file, there's a risk the formatting is lost.

 

As it is, that file is not a CSV.  CSV stands for comma separated variable and the columns in that file are not comma separated.  They may be trying to use tab separated columns but when I try to import it, it's messed up, because there are tabs between  text in fields (like the description) as well as between columns.  Power Query is splitting  it up where it sees a tab.

 

So, if that is an accurate copy of one of your files, the process by which the are exported and created is not really working.  The export of the data needs to be changed so you get files you can work with, preferably proper CSV files.

 

Regards

 

Phil