Forum Discussion
Advocate IIGateway will not connect to an Excel File due to naming convention
KarlCullimore,
What error message do you get? I have no issues connecting to the Excel file which has spaces in file name under gateway, please review the following screenshot.
Regards,
Lydia
Helper IKarlCullimore do you have spaces before and after the dash?
Data Management Best Practices for file naming recommends to:
- Avoid Special characters such as ~ ! @ # $ % ^ & * ( ) ` ; < > ? , [ ] { } ' " and |
- Do not use spaces. Some software will not recognize file names with spaces, and file names with spaces must be enclosed in quotes when using the command line. Other options include:
- Underscores, e.g. file_name.xxx
- Dashes, e.g. file-name.xxx
- No separation, e.g. filename.xxx
- Camel case, where the first letter of each section of text is capitalized, e.g. FileName.xxx
Thats why when you changed it to a 20170101_ABC.xlsx it worked.
BR
BR
KarlCullimoreThanks Bordalos it did indeed have spaces before and after. As I need to update my company docs for our self service contingent, I could do with knowing whihc microsoft site this comes from so that I can add it to company documentation on the Power BI gateway. If you have a link that would be very much appreciated.
KarlCullimore,
What error message do you get? I have no issues connecting to the Excel file which has spaces in file name under gateway, please review the following screenshot.
Regards,
Lydia- KarlCullimore
Hi Lydia,
I cannot reproduce , the error message was an unable to connect issue. But it currently reading as connection succesful. Im blaming the hidden character issue.
Thanks