Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |