DataSource error

[mpsAutomation]

Hi, I have a sharepoint url that contains a # (..\#210570 Electrotech - New Barrel Cellar\Quote..), when I try to add my source # is changed to %23 (..\%23210570 Electrotech - New Barrel Cellar\..), but I get a data source error, anyone has encounterd this error before?

[v-jingzhang]

Hi @mpsAutomation 

Some characters are not allowed in the URL string. You need to convert them into corresponding Percent encodings. So space should be %20, # should be %23, $ should be %24, etc. Please check if there is any character being not changed correctly. 

Percent-encoding - Wikipedia

In addition, are you trying to connect to a file stored in SharePoint?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mpsAutomation]

Hi @v-jingzhang ,  The file is on sharepoint and I have replaced # and spaces, I have succesfully used other files from sharepoint but for some reason I can't link the ones that have %23 and get the error as per the screenshot