Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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.
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:
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.
@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.
Excel will treat is as text when it starts with '. But not sure the same is true when you export it like '2010-02-02
That did it. Thanks for walking me through the thought process.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |