Error message: "Expression.Error: There weren’t enough elements in the enumeration to complete.."

[tomekm]

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.

[lbendlin · Accepted solution]

you are trying to connect to the fifth document in the library but it contains only four (or fewer) documents.