SharePoint List Interaction

Roswat · ‎11-07-2016

I have a Sharepoint Web Page which has >1000 rows. When I hit 1000 records I receive an error "Limit of 1000 values reached". Is there any way I can lift that restriction ?

Anonymous · ‎11-08-2016

Hi @Roswat,

You can firstly load data from SharePoint List to SQL Server using SQL Server Integration Services by following the instructions in the article below. Then connect to SQL Server from Power BI Desktop, for more details about using Power BI Desktop to work with SQL Server, please take a look at this blog.

Using the SSIS OData Source Connector With SharePoint Online Authentication
Extracting and Loading SharePoint Data in SQL Server Integration Services

Thanks,
Lydia Zhang

Greg_Deckler · ‎11-07-2016

Seems like you are hitting the 1000 item limitation of the SharePoint list service, see this thread:

https://social.technet.microsoft.com/Forums/en-US/57c2f0c3-a6aa-4384-b0ee-35bc063aee59/power-bi-for-...

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...