SharePoint Folder

[ahmadibrahimbus]

Hello , I have a strange problem. I have a power bi report which is connected to sharepoint folder.Acutually I'm able to referesh my tables on power bi Desktop.However in power bi service I got the below problem:

DataSource.Error: <ccon>Web.Contents failed to get contents from the sharepoint Root.

anyone has encountred this error.

many thanks for your help.

[ahmadibrahimbus · Accepted solution]

to be honest 10 days I have a problem between sharepoint and power bi service communication and yesterday it's solved while I have not changed anything!! it's really weired.

Thank you @v-jianboli-msft  and @ibarrau  for your replies.

[v-jianboli-msft]

Hi @ahmadibrahimbus ,

Please try:

Check Permission and Clear Data Cache

Clear permissions in Power BI:

Enter the url, click on the drop down arrow, and then select Edit.

Another Power BI window will open, so open the Power Query Editor window. Click on Data source settings menu option.

Click on the url.

Click on the arrow for Clear Permissions and then click on Clear Permissions.

Click Delete.

Click Close.

Click on a query, like Selected Project.

Click on Edit Credentials.

Click Sign.

Enter your credentials.

Click Connect, once the sign was successful.

Clear data cache:

1. Select File.
2. Go to Options and Settings.
3. Under Options, select option to Clear Cache.

Check Project/Site URL

• Make sure to include "https://" in the site URL.
• Make sure there are no typos in the site URL

For more details, please refer to:

Power Query SharePoint Online list connector - Power Query | Microsoft Docs 

Best Regards,

Jianbo Li

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

[ibarrau]

Hi. It looks like you are trying to get the folder incorrectly, using a web.contents functions instead of a prebuilt sharepoint one. You can get data from Sharepoint Folder as a connector. That one shouldn't have an error like that. As an alternative you can also do it like this post: https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de

I hope that helps,