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
    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! 

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Can you share the CSV file (or a sample of it), indicating the column that you want to remove duplicates from?

And also the M code you were using

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.