Forum Discussion
.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 the .pbix viz showing the actual part ID:
Here's the Power Query field:
How do I prevent the .csv export from converting my text strings into dates?
Thank you.
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.
6 Replies
In the model View. You have modeling tab. There you have the option to change data type and format
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.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.
