Forum Discussion
Convert to Number error
Hi Anonymous ,
If you don't want to automatically detect the data type, you can turn off the related functions through the following article.
Data types in Power Query | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If you don't want to automatically detect the data type, you can turn off the related functions through the following article.
Data types in Power Query | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I have done this as it was the easiest way to create the result I want, but not sure why it wouldn't accept my change data type