Random SharePoint Folder Connector Error

[Darren_Linc]

Good Day,

Anyone seen an error like this? Started happening this morning, I think it might be permissions related? If anyone could confirm I'd most grateful.

DataSource.Error: Web.Contents failed to get contents from 'https://linccymruadmin.sharepoint.com/team-sites/ICT-team/_api/web/lists/getbyid('6f350673-e2e1-4368...' (500): Internal Server Error
Details:
DataSourceKind=SharePoint
DataSourcePath=https://linccymruadmin.sharepoint.com/team-sites/ICT-team
Url=https://linccymruadmin.sharepoint.com/team-sites/ICT-team/_api/web/lists/getbyid('6f350673-e2e1-...

[v-yulgu-msft · Accepted solution]

Hi @Darren_Linc,

Can you connect to a SharePoint list with the same URL successfully? Does it work? 

Based on my research, this error is most likely related to SharePoint side. Please use Fiddler to capture a network trace of the request that's being sent to the SharePoint server.  In order to get the Fiddler trace, you need to start Fiddler, enable the Tools > Fiddler Options > HTTPS > Decrypt HTTPS traffic option, start the capture, reproduce your issue, then stop and save the capture. 

If possible, you can also update Power BI desktop to latest version for a test.

Regards,
Yuliana Gu

[Darren_Linc]

Thank you Yuliana, it would appear that it's an issue on the SharePoint side, as a result I've decided to remove the problem and start utilising Onedrive in the PBI shared workspace that we use. I'm thinking this will be a better long-term option too.

[zk01]

Hi there. I have the same error (did not experience this previously, but now I am). What I find odd is that I can connect to a subsite using the SharePoint folder connector, but not the parent. I can also connect to the parent using the web interface, but not Power BI desktop....

Is there a setting or configuration on the SharePoint side that I am missing?

[zk01]

I have the same error. What is strange is I can use the SharePoint folder connector to connect to a subsite, but I get the same error above when trying to connect to the parent site. Is there a setting or configuration I am missing?