Unable to connect to the remote server

Hi Anonymous ,

From your description about the URL https://xxx.sharepoint.com/sites/xxx/, we know your data source is from SharePoint online. In your scenario, you have only data source which it is SharePoint (SharePoint online), it means that you needn't to install and configure gateway.

If you want to connect to SharePoint online folder in Power BI Desktop, please use SharePoint Folder connector and use the URL below.

https://xxxxx.sharepoint.com/sites/<sitename>

Or you can try to follow steps below to work around the issue.

In Power BI Desktop, please firstly go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop and clear permissions for stored SharePoint data source.

Secondly, use Web connector to get data instead of the SharePoint folder connector .

a.To connect to Excel that is located under Documents of SharePoint online site, please use the URL below.

https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx

b.To connect to Excel that is located under a folder in SharePoint online Documents, please use the URL below.

https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.