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.
When im trying to change my datatype from ABC123 to whole numbers it doesnt work. There was a row with text there before but i replaced the data with 0. The query has been appended before so i tried to replace the row with the text in the previous query as well. This didnt work. Is there a way for me to change the datatype without starting over?
Solved! Go to Solution.
It will tell you why it is having trouble. You can then clean that up as well before you do the ABC123-Integer conversion. In my sample below I entered the text "aaa" in a column of numbers.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIt will tell you why it is having trouble. You can then clean that up as well before you do the ABC123-Integer conversion. In my sample below I entered the text "aaa" in a column of numbers.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Anonymous ,
If the column has the same sub-String such as "ABC", we can use Table.ReplaceValue to remove it and then change it to whole number.
Best regards,
What error message are you getting?
If you use the View menu->Column Quality you can track these issues down.
Also, at the bottom of the screen, profiling can be changed to look at the whole dataset rather than the first 1000 rows
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.