Sharepoint Connection Error

[FaisalBaloch]

I am getting below error while connecting excel files on Sharepoint location. I can manually access all the files but Sharepoint Folder is throwing below error. Please advice:

[v-jingzhang · Accepted solution]

Hi @FaisalBaloch 

It seems you didn't use the correct connector or enter a valid URL with the correct format.

If you want to connect to a single Excel file stored in Sharepoint online, copy its link from Sharepoint online and use Get data > Web in Power BI Desktop. It's similar to connect to an Excel file stored in OneDrive for Business. 

Use OneDrive for Business links in Power BI Desktop

If you want to connect to a Sharepoint folder which contains multiple Excel files and hope to combine them into one, you can use the SharePoint Folder connector. Paste the address into the Site URL text box in the SharePoint folder dialog box, which is similar to https://contoso.sharepoint.com/marketing/data.

Power Query SharePoint Folder connector

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@FaisalBaloch ,refer this past solution

https://community.powerbi.com/t5/Desktop/Error-connecting-to-Sharepoint-Online/m-p/1461133

also check this

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/