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.
- ns710 years agoRegular Visitor
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?
- gazzatopdude10 years agoAdvocate I
Is this still the case that we cannot use Power BI to connect to an "on-premises sharepoint" server
I am trying to use power BI to "GET DATA" from a sharpoint site in this fashion