cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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

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.

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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.

 

Syndicate_Admin
Administrator
Administrator

@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 loading 20 rows into the PBIx. Any idea why?

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.

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Users online (1,862)