Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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! 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

 

Is it a cell-level error? If so, I found a same error in below doc. It may be helpful. 

Dealing with errors | Microsoft Docs

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.