Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
nicke_
New Member

Sharepoint List only returns 100 first items

Getting data from sharepoint list only returns the first 100 items. This used to work with an earlier version of powerbi desktop(like a month ago) but is not working anymore. This is a on-premise sharepoint 2013. The sharepoint api returns 100 items by default. I can see all the items fine when viewing from the preview the Edit Query window but when trying to Close&Apply the changes or trying to refresh data it only returns the frist 100 items. 

 

I tried creating a completely new list but that did not help with this issue.

 

Thanks

 

Niklas

4 REPLIES 4
shiv1002
Regular Visitor

@nicke_ and @Anonymous any lead on how to fix this?

Anonymous
Not applicable

Hi @shiv1002,

 

No updates from Power BI team till date.

But as of now I managed  it by connecting sharepoint through ODataFeed option through which I can get all the required no. of rows.

Hope this could help u too 🙂 .

@Anonymous Thanks for responding.

Interestingly, I am able to get all items from a standard SharePoint list, some 10,000 plus rows, however, I am facing the limits items issue when connecting to an external list. This list is not even available when trying Odata method. I will see if I can get the required information from SQL.

Anyone else who needs help with Odata, here is quick link https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-sharepoint-list-library.aspx 

Anonymous
Not applicable

Hi All,

Surprised to see that the same issue still exist!

Is there any way to get over this issue?

I m still facing the same error where i cannot get more than 100 records from Sharepoint List to Power BI.

PLz do reply its critial.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors