Forum Discussion

tbauch's avatar
tbauch
Frequent Visitor
7 years ago
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 ...
Need Help
  • tbauch's avatar
    tbauch
    7 years ago

    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. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

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.

 

tbauch's avatar
tbauch
Frequent Visitor
7 years ago

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. 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    7 years ago

    Are you opening CSV in excel? If so please open it in Textpad and check. Excel might convert this.

    • tbauch's avatar
      tbauch
      Frequent Visitor
      7 years ago

      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. 

      • tbauch's avatar
        tbauch
        Frequent Visitor
        7 years ago

        That did it. Thanks for walking me through the thought process.