Power BI connected to SharePoint Online list with 6000+ rows, but faces 5000 row import(Threshold) limit. Solutions?

Question

Question : I've connected Power BI to a SharePoint Online list using the SharePoint Online connector. The SharePoint list contains over 6000 rows of data. However, when I try to import the data into Power BI, I encounter a threshold limitation error stating that only 5000 rows can be imported. How can I address this issue and successfully import all the data into Power BI?

Error :
The dynamic invocation request failed with error: Unexpected error occurred when calling the ApiHubsRuntime API: 'Microsoft.Azure.ProcessSimple.Data.Entities.Exceptions.ProcessSimpleDataException: The ApiHubsRuntime API call failed with http status code 'BadGateway' and response content '{ "error": { "code": 502, "source": "msmanaged-na.azure-apim.net", "clientRequestId": "78e643c2-f1e6-4ae0-8a5e-fde2d5d2e517", "message": "BadGateway", "innerError": { "status": 502, "message": "The attempted operation is prohibited because it exceeds the list view threshold.\r\nclientRequestId: 78e643c2-f1e6-4ae0-8a5e-fde2d5d2e517\r\nserviceRequestId: 71f81da1-b08e-5000-24c0-d2da4c63cb7e", "source": "https://lkq.sharepoint.com/teams/QueryManagementSystem_KAOMDM/_api/web/GetFolderByServerRelativePath(decodedUrl=@p)?$expand=Folders,Files&@p='%2fteams%2fQueryManagementSystem_KAOMDM%2fLists%2fProduction+Tracker++2024'", "errors": [ "-2147024860", "Microsoft.SharePoint.SPQueryThrottledException" ] } } }' at Microsoft.Azure.ProcessSimple.Data.DataProviders.HttpClientDataProvider.<>c__DisplayClass49_12.<<CallService>b__0>d.MoveNext() in C:\__w\1\s\src\processsimple\Roles\ProcessSimple.Data.Shared\DataProviders\Services\HttpClientDataProvider.cs:line 664 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.WindowsAzure.ResourceStack.Common.Algorithms.AsyncRetry.<Retry>d__31.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.

Answer 1

I am Importing the data from share point list to power bi, but it is loading only below 187 rows only.
what is the solution for this ?

Answer 2

Dear Raj_BRD,

Thank you for reaching out to the Microsoft community. We are happy to offer our help.

We'd love to help, but considering we focus primarily on general queries in Microsoft 365 apps, we may have limited resources on Power BI.

At the same time, considering that we have a dedicated channel to the Power BI forums – Microsoft Fabric Community, for you to receive proper assistance, we sincerely recommend that you go to that community and post a new thread, the members and engineers there will focus on the specific situation on your side and share specific suggestions. We are confident that our experts on that team can take care of your query effectively and accurately.

Thank you for your understanding and cooperation! I hope you stay safe and healthy always.

Sincerely

Sean | Microsoft Community Moderator