Error - DataFormat.Error: We couldn't convert to Number. Details J7510

[delgadomk]

Hi,

I keep receiving an error when I import my excel file into PowerBI Desktop.  I think what is happening is that in some of the fields, there is a comma.

For example, I have a column titled Procedure Code and typically Procedure codes are just all numbers like 99213 but there are occassions when a Procedure Code will contain a modifier and that modifier is identified after theProcedure Code and is separated with a comma: 99213,PRO or 99213,52,AS.  How can I get PowerBI Desktop to reverse the error and just import the data like it is in the excel file?

Thanks,

Kim

[Anonymous]

Thanks that worked for me. In advanded editor when selecting Changed Type and finding the field NAMEID it showed 

... {"NAMEID", Int64.Type}, ....

Then I just changed it to

... {"NAMEID", type text}, ....

and it worked 

[Anonymous]

This works for me too! 

Thank you!