Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

An error occurred in the ‘Sample File (2)’ query. Expression.Error: There weren't enough elements in

I am experiencing the error after I have removed the data and uploaded it again in Data source-

An error occurred in the ‘Sample File (2)’ query. Expression.Error: There weren't enough elements in the enumeration to complete the operation. Details: [Table]
 
How can I rectify this?
 
This is happending for all my 3 queries.
 
 
 
  • Hi Anonymous ,

     

    you need to  go the Sample file of that query and check the steps

  • Revisit any steps in the Power Query Editor that access specific rows, columns, or positions. Make sure that they are still applicable to the modified data structure.

    Check the variable you assigned to SampleFile (I assume you need to check the file path there) 

     

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    Hi Anonymous ,

     

    you need to  go the Sample file of that query and check the steps

  • Revisit any steps in the Power Query Editor that access specific rows, columns, or positions. Make sure that they are still applicable to the modified data structure.

    Check the variable you assigned to SampleFile (I assume you need to check the file path there)