Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

DataFormat.Error: We couldn't convert to Number.

‎01-18-2021 04:36 AM

Capture.PNGI want it as text and it is in text format but still it shows error Capture.PNGCapture.PNG

Labels:
Message 1 of 5
813 Views
0
1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

‎01-18-2021 04:41 AM

@Anonymous 

At a guess, Power Query has probably added a step on importing the dataset where it attempts to establish a type for each column. Look for the "Changed Type" step in the list and delete the conversion pertaining this column.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Message 4 of 5
809 Views
4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

‎01-18-2021 04:41 AM

@Anonymous 

At a guess, Power Query has probably added a step on importing the dataset where it attempts to establish a type for each column. Look for the "Changed Type" step in the list and delete the conversion pertaining this column.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Message 4 of 5
810 Views
johnmcauliffe
New Member
In response to PaulDBrown

‎02-02-2023 08:15 AM

Hi Paul - any thoughts on this one?

 

Similar issue but it is not being caused by any Changed Type step. On a filter step, Power Query seems to be attempting to convert to number when all the data has been marked as text and was at no point otherwise.

Message 5 of 5
274 Views
0
PC2790
Community Champion
Community Champion

‎01-18-2021 04:40 AM

Would you be able to share your pbix file removing the sensitive data?

Message 3 of 5
809 Views
0
amitchandak
Super User
Super User

‎01-18-2021 04:39 AM

@Anonymous , OPen Power Query, Right-click on advance editor an find your column and carefully change data type

 

One part video cover data type correction: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2



Message 2 of 5
809 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All