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("https://xxxxxxxx.sharepoint.com", [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
Get a sneak peek into this year's Power Platform Conference Keynote.
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
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!
