SharePoint list limitations

[leigh_yh]

I am building a new reporting package for my company using PowerBI. The main data source is a SharePoint Online list to which multiple users will add project data. I expect this list to grow to over 10,000 rows over the next two years. Are there limitations to using a list? Should I consider connecting the list to a database and querying that? New to this - thanks for any help!

[v-juanli-msft]

Hi @leigh_yh 

There are two methods to connect to Sharepoint list.

Get SharePoint List/Library Using OData Feed

For a large Sharepoint list, it may slow down the performance for the report.

Power BI for Large SharePoint lists

"Power Query specifications and limits".

Users can upload files to Power BI service up to 1 GB in size per file.

Please learn more here: Limitation of data size in the Service

To improve the performance for large sharepoint list data,

Besides your method,

You could connect to sharepoint list with Power BI in direct query.

sharepoint-real-time-reporting-with-power-bi

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.