Unable to load SharePoint list data into Power BI

[Anonymous]

Hi Team,

I was trying to load the data from multiple SharePoint sites with different queries and trying to load the data into Power BI.

during the load it fails with below error

We have no issues when pulling data from UAT lists that has around 100 records. but when pulling data from Prod lists that has around 5,000 records it failed with above error.

A quick help would be much appreciated.

[Slambert35]

Hi HVardhan,

We are also seeing this issue when refreshing from multiple Sharepoint sites. We have found however it works if you refresh each query seperately but not when you run them all at the same time. This only appears to be an issue in the desktop as we do not see this in the service.

[Anonymous]

Hi @Slambert35 ,

Thanks for the prompt reply.

I have tried refreshing individual query after repointing all queries to Prod sites from UAT when I click on close & apply it does execute all queries and erroing as above.

even to refresh it in service, we need to first save query modifications in desktop.

Any alternavtive approach that could solve this problem?