Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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)
Hi @PeterNowak ,
Consider whether the rows have got the max limitations in Power Query.
Similar threads:
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.
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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |