Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I changed the format of a column from number to text, but I still receive error message.
It says for the text "could not convert" to number.
Why does it want to still convert to number? How can I solve it?
Thanks!
Hi @AgnesHU ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Is this in Power Query? What's the data source?
Power Query transforms are a series of steps so it may be that the change to number type is still in one of the query steps even though later on the change to text is attempted. So please check the query steps.
If you can't get anywhere, please post the code from the Advanced Editor. And a small data sample.
User | Count |
---|---|
89 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |