Column Tools

[Cyy]

utilizing column tools unable to change data type text to whole number

[Cyy]

Thank you really helped my attention to detail fixed problem

[Anonymous]

Hi @Cyy , hello DataNinja777, thank you for your prompt reply!

If you find any answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

[DataNinja777 · Accepted solution]

Hi @Cyy ,

In Power BI, if you are unable to change the data type from text to whole number using the column tools, it could be due to a few reasons. One common issue is the presence of non-numeric values in the column, such as letters, special characters, or blanks, which prevent the conversion. To resolve this, you can replace non-numeric values with null, filter them out, or clean the data in Power Query. Another possible reason is a data type conflict, where the column is being used in a calculated column, measure, or relationship, restricting changes to its data type. In such cases, you may need to modify or remove the dependencies.

Additionally, if the data is imported or transformed via Power Query, you might need to change the data type in Power Query itself rather than using the column tools. This can be done by opening the Power Query Editor, locating the column, and updating the data type. Lastly, if the data is connected through a live connection or DirectQuery, certain transformations, including data type changes, may not be permitted directly in Power BI. In such situations, adjusting the data type at the source level may be necessary. 

Best regards,