sharepoint list connection

Question

I have created my reports in power bi desktop and published to power bi web in order to publish to my reports to the web. The data is coming from a SharePoint List which is on prem but has a .com.au address which is what it is linking to in power bi desktop.When&nbsp;I open power bi web to refresh the data or schedule a refrsh I get this error:&nbsp;"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Your data source can't be queried because the credentials are not provided. Please provide your credentials and try again."&nbsp;To edit credentials it always says authentication method anonymous, I change it to windows (apparently it doesn't require to enter my creditials) but then gives me this error:&nbsp;"Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources."&nbsp;How do I check what windows credentials it is using? and why doesn't it work?&nbsp;Without linking to the data source I am therefore unable to schedule a refresh which is rather annoying.&nbsp;Logging into power bi web without first going through power bi desktop I don't even get to see the datasets my reports are coming from and it wont let me connect through the get data to the sharepoint site even, giving me the error:&nbsp;"The URL is not valid or you do not have permission to the site. Please check the URL and make sure you have permissions to the site."&nbsp;

guyinacube · Answer

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?&nbsp;
&nbsp;
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.
&nbsp;
Of note, the Get Data &gt; Files &gt; SharePoint &nbsp;only works with SharePoint Online. That can't be used with an on-premises SharePoint server.

ns7 · Answer

The SharePoint is on prem but has a .com.au so it accessable online, does Get Data &gt; Files &gt; SharePoint&nbsp;&nbsp;only work for cloud?

guyinacube · Answer

Yes I mentioned above that the GetData experience is just for SharePoint Online.
&nbsp;
Can you verify the zone the web site is in?

vicky_song · Answer

ns7, the error message indicates that either the SharePoint list URL is invalid or you do not have required permissions. So,&nbsp;are you able to connect to that SharePoint list with your Windows Credential in IE or&nbsp;in Power BI Desktop?

ns7 · Answer

I have administrator access to everything on the SharePoint Site, I have no problem connecting to the site in IE and it works fine in Power BI Desktop.

Forum Discussion

Related content

Sharepoint list mirroring

OData Error When Connecting to SharePoint Online

Connect to Sharepoint Recycle Bin List

Sharepoint Connection

Connecting to sharepoint