Compound indexes are created on all supported combinations of navigation hierarchies and Key Filters. Single column indexes are created on all supported Key Filter fields except for the Content Type and Choice fields. When automatic index creation is enabled, indexes are created automatically for the fields that you add to the navigation tree and Key Filters. If you clear the recycle bin they are no longer counted.īy default, SharePoint performs automatic index creation. If you move items into the Recycle Bin, those items will still be counted when determining whether the filter expression exceeds the List View Threshold. Here are a couple of tidbits that may (or may not) be helpful. Does anyone know why the query returning 3858 rows fails? I understand the 5000 rows limit when using SharePoint views but I don't understand what other limit I seem to be hitting here. If I add more filters to the third query to reduce the number of rows, it works. The only difference I can find is that the third query should return 3858 rows the other queries all return fewer rows. = OData.Feed("" & "_api/web/lists/getByTitle('Statistics')/items?" & "$select=Date, GroupBy1, GroupBy2, Value" & "&$filter= Title eq 'Clients by status'", null, )Īlthough all three queries are similar in design, only the third one fails. = OData.Feed("" & "_api/web/lists/getByTitle('Statistics')/items?" & "$select=Date, GroupBy1, Value" & "&$filter= Title eq 'Potential counselling income'", null, ) I have several queries which extract different types of data from this list based on the values in the Title or GroupBy1 columns (both of which are indexed): = OData.Feed("" & "_api/web/lists/getByTitle('Statistics')/items?" & "$select=ID, GroupBy2, Date, Value" & "&$filter= GroupBy1 eq 'Enquiry'", null, ) I checked the SharePoint list and it has 5117 items. OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (The attempted operation is prohibited because it exceeds the list view threshold.) ![]() OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. I now get the following error: DataSource.Error: .Resources.HttpResource: Request failed: However, after a few days of working, the refresh has failed again on the same table. After looking up ideas online I rewrote the query to use an OData connection rather than the standard SharePoint connector and this seemed to work. ![]() I recently hit a problem when one of the lists went above 5000 items and the refresh failed. I have a Power BI report that is based on a set of SharePoint Online lists.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |