File name contains special character cause error?

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

Hi,

pls see this post for my earlier query for this. 

https://community.fabric.microsoft.com/t5/Desktop/DataFormat-Error-The-input-URL-is-invalid-Please-p...

[danextian]

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]

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

[danextian]

Try using a different file with the same name.