Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SharePoint List fails to load

Hey All, I am trying to load a list from SharePoint. The issue is that I can see only 600 records out of 1006. Looking at the query Editor I see 4 steps.   1. Source - Looks fine and loads all r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Updates...

 

Not sure about the root cause, but seems like one of the columns that I tried to import is corrupted.

I started to iterate and import the list again and again.

I started with 1 column and each iteration I have added another column until I had all necessary columns I need for my report.

 

When I'll have a bit more time to investigate, I will return with more details.

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Hey All,
Spoiler
[Duplicate post as did not get answers in the desktop furom]
I am trying to load a list from SharePoint.
The issue is that I can see only 600 records out of 1006.
Looking at the query Editor I see 4 steps.
 
1. Source - Looks fine and loads all records.
2. Added Index - Looks fine and all records are still there.
2019-01-07 10_18_55-Untitled - Power BI Desktop.png
 
 
 
 

3. Kept Errors - Shows "This table is empty."message.
4. Reordered Columns  - Shows "This table is empty." message.
 
2019-01-07 11_16_18-Untitled - Power Query Editor.png
 

 

 
Creating a new visualization, shows only 600 Records from the original list.
2019-01-07 11_23_49-Untitled - Power BI Desktop.png

 

 
 
 
 
 
 
 
 
Additional info:
  • I worked with another list before and had no issues.
  • This is a workflow, maybe the issue lays there?
 
Any idea how to fix this?

Thanks a lot!
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Updates...

     

    Not sure about the root cause, but seems like one of the columns that I tried to import is corrupted.

    I started to iterate and import the list again and again.

    I started with 1 column and each iteration I have added another column until I had all necessary columns I need for my report.

     

    When I'll have a bit more time to investigate, I will return with more details.