Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Team,
I have a column wherein it is mixed of Numerical, string and Alphanumerical but string and Alphanumerical reflected with errors. Please assist me to resolve this.
Solved! Go to Solution.
Hi @Revathi_Kannan ,
I suspect that Power Query has auto-detected your column types and has converted this column to number type.
Select the 'Changed Type' step after the 'Promoted Headers' step then change your [Tax2] column type to Text. Choose to replace the existing step, rather than creating a new one.
Pete
Proud to be a Datanaut!
Hi @Revathi_Kannan ,
I suspect that Power Query has auto-detected your column types and has converted this column to number type.
Select the 'Changed Type' step after the 'Promoted Headers' step then change your [Tax2] column type to Text. Choose to replace the existing step, rather than creating a new one.
Pete
Proud to be a Datanaut!
Hi Ba_pete,
Thanks for your reply. But still i am getting an error.
Ok, but that's not on the table you've posted about. You posted about AgencyResponse_xl, which now appears to be working.
Pete
Proud to be a Datanaut!
Hi Ba_pete,
Sorry for the confusion. It is working fine now. Thanks a lot.
No problem, happy to help.
Don't forget to give a thumbs-up on any posts that have helped you 👍
Pete
Proud to be a Datanaut!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.