Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

404 Not Found Expanding Items in SharePoint List Using API v2.0

I have a report that connectes to several SharePoint Online lists using API version 2.0


It has been failing to refresh recently with the following error in PBI desktop when trying to expand the table column called Items:

 Source = SharePoint.Tables("", [Implementation="2.0", ViewMode="All"]),
MyItems = Source{[Id="cac0fb18-acdb-4222-b324-2390b6649ae1"]}[Items]


This looks like something related to pagination? How can I get past this issue?


API v1.0 works OK but I have a few of these lists so I would rather avoid the work of updating all the queries to handle the data schema of the 1.0 API


Any help greatly appreciated.


Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors