Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

File name contains special character cause error?

Hi,

 

I found it has error if I put special character in file name when get data. 

Is this bug? 

 

 

without '#' > no error

 

with '#' > error

 

and also found from Folder name that

it used to get error if name contains '+' that
'LGU+ Site Progress' > error

'LGUplus Site Progress' > no error

 

 

 

General Comment
Need Help
Show and Tell

5 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

    I can't reproduce it. I don't think the filename is the problem. What does the error say? Possibly a corrupted file or a mismatched extension.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      uhm it's so funny.. I tested put # and returned, put and returned repeatadly many times but from my end, # keep causing error. 

       

       

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        1 year ago

        Try using a different file with the same name.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

    Could you provide the error message from Power Query? Based on my tests, special characters do not affect file reading.

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.