Forum Discussion

leigh_yh's avatar
leigh_yh
Frequent Visitor
7 years ago

SharePoint list limitations

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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.