Forum Discussion
Solved
.CSV export incorrectly converting text to date
I am exporting data from my .pbix to .csv but some of my hyphenated part IDs (field is text in Powr Query) are being converted into dates. Here's the .csv Part ID shown as a date: Here's ...
amitchandak, WordPad shows that it's exporting correctly. It's only when I open in Excel that it coverts. I'll try to use the import wizard in Excel to better control the data types.
Thanks for the reply, amitchandak. If you look at my post, you can see that the data is already formatted as text.
As shown in OP:
The "ABC" indicates it's text
It appears that the conversion is taking place during the export process.
Are you opening CSV in excel? If so please open it in Textpad and check. Excel might convert this.