Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Removed Duplicates is giving Error: DataFormat.Error: We couldn't convert to Number.

Hi there    I am new to Power BI. I've been trying to remove duplicates from a list of email addresses.  No matter what I've tried this keeps giving me the Error: DataFormat.Error: We couldn't con...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi everyone

    Thanks for all your suggestions. I tried them all. Finally the only thing that worked was deleting the entire query, exporting a fresh CSV and building it again. 

    Makes me think it may have been something to do with the data source Permissions (?). Will try clearing and updating the permissions if it happens again (hopefully not). 

    Thanks again! 

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

 

If possible to do, please delete the Change Type step on your csv and then remove the duplicates.

So you can check which data is causing you an error. 

After checking and cleaning, you can do the change type.

 

Hope this helps