Showing results for 
Search instead for 
Did you mean: 
New Member

Changing Data Type problem



When I am trying to change the column type from Text to Dollar value, I am getting an error message “The selected column has an existing type conversion, would you like to replace the existing conversion, or preserve the existing conversion and add the new conversion as a separate step?” When I press “Replace Current” to convert, all the fields show “Error”.


Similarly, I am also not able to convert data type to range and getting the same message.


Can anyone please help me how to solve this? Where am I going wrong?

Microsoft v-huizhn-msft

Re: Changing Data Type problem

Hi @whoizdeepak,

As I tested, I create a new table in Excel, the type of dollar column is Currency. Then load the table into Power BI, it will change the type to number automatically.




How do you load your resource data into power bi? Please check if there is the query state in Edit Query page. If there is not, please check your resource data's type.

Best Regards,

New Member

Re: Changing Data Type problem

Check the locale. It should be concurrent with the dataset being used.

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors