Forum Discussion
Error message: "Expression.Error: There weren’t enough elements in the enumeration to complete.."
Hi,
I’m getting this error message when creating a pbi dataflow: “Expression.Error: There weren’t enough elements in the enumeration to complete the operation”. Please see attached screenshot. Not sure exactly what it means/how to solve it.
Here’s the initial code:
let
Source = SharePoint.Contents("https://xyz-my.sharepoint.com/personal/name"),
Documents = Source{[Name = "Documents"]}[Content],
Content = Documents{4}[Content],
#"PO Temp" = Content{[Name = "Temp"]}[Content],
My_Load2 = #"PO Temp"{[Name = "Load"]}[Content],
The 3rd line of this code is where the error occurs.
you are trying to connect to the fifth document in the library but it contains only four (or fewer) documents.
1 Reply
- lbendlin
Super User
you are trying to connect to the fifth document in the library but it contains only four (or fewer) documents.