SharePoint List Interaction

[Roswat]

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]

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]

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-...