Forum Discussion
Helper IIIUnable to connect: We encountered an error while trying to connect to Excel - Gateway
No,
The UNC path is the name of the server. Eg. If I named my Server FileShare1 my unc path is (not case sensitive) : \\FileShare1
tek is the name of your domain. you will need to ask IT what the server name is and maybe get the full path as T: is just a letter to mask \\servername\folder1 etc.
Helper III
Hello, still no luck where are these logs that I can provide?
| Activity ID: | 76b593ed-4e3b-49d4-a66c-3ecee0ee80ce |
| Request ID: | 4e059a82-c9d3-edc2-6d7d-51891918c3b3 |
| Cluster URI: | https://wabi-canada-central-redirect.analysis.windows.net |
| Status code: | 400 |
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
| Time: | Mon Apr 16 2018 08:42:07 GMT-0700 (Pacific Daylight Time) |
| Version: | 13.0.4965.184 |
| Tak Dashboards: | Invalid connection credentials. |
| Underlying error code: | -2147467259 |
| Underlying error message: | The credentials provided for the File source are invalid. (Source at t:\dispatch\1. dispatch\2. reports\pipe and completed loads report 2018.xlsx.) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | File |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | T:\Dispatch\1. DISPATCH\2. REPORTS\Pipe and Completed Loads Report 2018.xlsx |
| Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
| Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"File","path":"T:\\Dispatch\\1. DISPATCH\\2. REPORTS\\Pipe and Completed Loads Report 2018.xlsx"}] |
| Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Advocate IIHave you tried using for full UNC path?
\\<servername>\Dispatch\1. DISPATCH\2. REPORTS\Pipe and Completed Loads Report 2018.xlsx
- benjaminhoang
Like this? which did not work unfortunatley.
- zylawys
No,
The UNC path is the name of the server. Eg. If I named my Server FileShare1 my unc path is (not case sensitive) : \\FileShare1
tek is the name of your domain. you will need to ask IT what the server name is and maybe get the full path as T: is just a letter to mask \\servername\folder1 etc.
- benjaminhoang
GREAT GUYS ONE STEP CLOSER. It shows my gateway and file are connected but when I try to connect the data set It shows I dont have any gateways configured.