Forum Discussion

user5566's avatar
user5566
New Member
8 years ago

CVS Columns Combined After PowerBi

Hello,   I am relatively new to PowerBi so with that out of the way, let me explain.   Two CSV files were imported to PowerBi from my Windows7 file explore.  The columns were nice and organized, ...
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi user5566,

 

=> however after setting up my PowerBi visualizations and saving the pbix, my CSV files are now completely different.

 

In your scenario, you have imported the CSV file to Power BI desktop and visualize it. Then you export the data in visual to a new CSV file. However all the data in this new CSV file is combined into one single column. Right?

 

I have made some test based on above steps. However I didn't encounter your issue. The new CSV file is working fine.

 

So could you please share us some screenshots of the steps that you imported the file and edit the query in Power BI? Also could you please share us your CSV file if possible? So that I can make some test in my environment and see if the issue persists.

 

Thanks,
Xi Jin.

user5566's avatar
user5566
New Member
8 years ago

Thank you Xi.

 

All I did was "Get Data", select my CVS, selected "Edit", and "Make First Row Header", then deleted the first row.

 

After I was done building my charts I "Saved".  I did not export anything.  I'll try to do the screen shots soon.