Forum Discussion
sharepoint list connection
Are you doing this through the personal gateway? Do you see the same error in the event logs? Can you get to the SharePoint site from where the gateway is?
Maybe also verify that the site URL is in your trusted internet zone with Internet Explorer? With a period in the URL, it will be treated as being in the internet zone, unless your organization is pushing that to the trusted zone by way of local policies. Worth checking. Windows credentials won't be passed when in the internet zone.
Of note, the Get Data > Files > SharePoint only works with SharePoint Online. That can't be used with an on-premises SharePoint server.
The SharePoint is on prem but has a .com.au so it accessable online, does Get Data > Files > SharePoint only work for cloud?
- GuyInACube10 years agoAdministrator
Yes I mentioned above that the GetData experience is just for SharePoint Online.
Can you verify the zone the web site is in?
- ns710 years agoRegular Visitor
I am not sure what you mean by web site zone?
- GuyInACube10 years agoAdministrator
The following KB talks about how to see what security zone a given page is in within Internet Explorer.
- Maexchen7 years agoFrequent Visitor
GuyInACube wrote:Yes I mentioned above that the GetData experience is just for SharePoint Online.
Hi GuyInACube, is that still the case? Or is there any workaround to connect to a data source on an on-premise Sharepoint (SP365)?
Maexchen