Forum Discussion

gtamir's avatar
gtamir
Icon for Post Patron rankPost Patron
8 years ago

#NAME?

Hi, After I loaded Sales table I got lot of errors in column "ProductName". The column in type TEXT. I went bake to the original excel file and found that there is a special character like +.  I lo...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi gtamir,

 

when you make a connection to an excel file the PBI validates the formulas you have in your book so if you have a column with formulas and one of those is incorrect it will return an error.

 

In this case what happens is that in that column on th excel file you have some formulas that aren't recognize so the error "#NAME?" appears.

 

I have simulated a file with that type of errors as you can see PBI is returning the same result as you have.

 

The error in the Excel file is that I made a formula that doesn't exist. Go back to your excel file and look for the same error and correct the formula.

 

Regards,

MFelix

 

 

  • gtamir's avatar
    gtamir
    Icon for Post Patron rankPost Patron
    8 years ago

    I found the problem. I opened csv file in excel. then saved it as xlsx. So far so good.

    After that I did something that I still have to investigate that when I saved it in another name it coused the error.

     

    49906#NAME?
      
    49906+ח.פBאקוסאפ ויט.מתיל12 

     

    The second one is the original and the first is the result.

    It is not the scop of the forum, but if you know what happend I'll be glad.

     

    Giora

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi gtamir,

       

      I think it may related to encode, maybe you can try to save your file as xlsx with unicode encode.


      Regards,

      Xiaoxin Sheng