Forum Discussion

tomekm's avatar
tomekm
Icon for Helper III rankHelper III
5 years ago
Solved

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

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