Expression.Error: <pii>There weren't enough elements in the enumeration to complete the operation

[PeterNowak]

Hello guys,

I'm facing an issue with a pbix file which is connected to several excel files which are uploaded on one drive. The error message appeared when I changed the location of some files from my PC to the one drive. Anyone has an idea what is the root cause of that?

Below error msg:

Expression.Error: <pii>There weren't enough elements in the enumeration to complete the operation.</pii>. <pii>#table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {})</pii>. ;There weren't enough elements in the enumeration to complete the operation.. The exception was raised by the IDbCommand interface. Table: Prices.

[PeterNowak]

@v-yingjl 

Hey,

I think the issue why the data cannot be loaded sits actually on the SP. When I changed the location of my files it looks like everything works properly. However, do you have any idea what kind of error can be this? 

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Details:
DataSourceKind=SharePoint
DataSourcePath=ondrivename/_vti_bin/ListData.svc/SolutionGallery
SPRequestGuid=fb50f99f-2050-3000-3c36-d7977a5bf81e
Url=https:onedrivename/_vti_bin/ListData.svc/SolutionGallery

Also on the SP i have 19 files and PowerBI is trying to load 20 rows into the PBIx. Any idea why (this 1 more "hidden" file is displayed as an error line)

[v-yingjl]

Hi @PeterNowak ,

Consider whether the rows have got the max limitations in Power Query.

Similar threads:

1. The remote server returned an error: (500) Internal Server Error. 
2. Power Query (Power BI) and SharePoint Lists 
3. SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl]

Hi @PeterNowak ,

It depends on what you did transformations on the table. 

In addition, when you change the file path, you should change it in Power Query first to prevent data source error.

Similar threads:

1. There weren't enough elements in the enumeration to complete the operation. when threre are no files 
2. ERROR: "There weren't enough elements in the enumeration to complete the operation" 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.