Iterate Over Web Pages using Web Connector

[Anonymous]

I am not able to connect to an excel in Sharepoint with this:

https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

It won't let me choose between Windows/Organizational account but shows the following message.

How can I change my login settings? They are not visible in data source settings.

[Anonymous]

@Anonymous,

Firstly, please go to File->Options and Settings->Data Source Settings->Global Permissions, click all the existing sharepoint excel data sources and click "Clear Permission". Then connect to the Excel in use web connector.

Secondly, if you are connecting to SharePoint excel, please use the URL below. If you are using SharePoint online, please use Organizational account authentication, if you are using on-premises SharePoint, please use Windows authentication.

https://your root site url/Shared%20Documents/yourfoldername/excelname.xlsx

Regards,
Lydia