Forum Discussion
Helper IIOptimization by choosing good data type
Hi, bboy0009
According to your description, your column is alphanumeral, if your column contains strings and numbers, I recommend that you use the Text format, because the data in this case exists strings, and we should use Text to identify it. In Power BI, this type should also be treated as text.
Whether it will have an impact if you want to convert the format needs to be judged comprehensively based on your business logic and existing operations.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IIHi
You understood the inverse of what I said.
There is already steps to change alphanumeric to text and I would like to delete them but I have a fear that after the delete, there could be some impact.
If not, if I had a choice between alphanumeric or text, what is the best to choose ?
Community SupportHi, bboy0009
According to your description, your column is alphanumeral, if your column contains strings and numbers, I recommend that you use the Text format, because the data in this case exists strings, and we should use Text to identify it. In Power BI, this type should also be treated as text.
Whether it will have an impact if you want to convert the format needs to be judged comprehensively based on your business logic and existing operations.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly