Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Changing data type to numeric values

Hi everyone Can someone assist me here please. I have 4 columns with numbers on Excel. I even manually change the data type to numbers on Excel. But when I load this spreadsheet on power bi, I don...
Data Protection
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for your feedback. I just opened a new pbi file and the problem disappeared.

    regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, Thanks a lot for your prompt feedback. 

I simply opened a new pbi file and managed to import the table with the correct format.

I think there was a problem with te first file, I'm wandering what could that be.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

There should be some thing wrong when you load data from Excel. 

Could you tell me what kind of data type will the columns from your first file work like, text or others? Please show me a screenshot with your column type in first file.

I think you can change the data format in Power Query Editor and Column Tools in Report View. Or you can delete the data model and load it again.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.