Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

PowerBi - There weren't enough elements in the enumeration to complete the operation

Steps to reproduce:

 

  1. Open PowerBi Desktop  v2.64.5285.741 64-bit (November 2018)
  2. Home tab -> Get Data ->More -> Sharepoint folder
  3. Place your SharePoint Online folder (example https://mycompany.sharepoint.com/sites/FirstFolder/SecondFolder)
  4. Authenticate with selection of your choice (in my case Organization Account)
  5. Click on Load Data. (unfortunately cannot add screenshot due to beatiful functionality of this web site)
  6. After some time getting error message There weren't enough elements in the enumeration to complete the operation

 

Please advise what might be the problem with the tool? Thanks 

Status: Needs Info
Comments
Anonymous
Not applicable

@Anonymous,

I am unable to reproduce this issue on my side. In step3, do you enter root URL of your sharepoint site? And in step 4, please use Microsoft account authentication.
1.PNG

In addition, what are the contents in your SharePoint site that you want to connect to?

Regards,

Lydia

Anonymous
Not applicable