Incomplete import of SharePoint List

[Anonymous]

I am trying to connect to a SharePoint list using Odata source and I get the following error:

The list actually has about 3000 records. In the Power Query editor it appears in the complete list, but in the Power BI I figure in the list with only 213 records.

Does anyone have any idea what may be happening?

From already thank you very much,

regards

[v-yuezhe-msft]

@Anonymous ,

Could you please click "view errors" to see detailed error and post the error message here? In addition, what is the result when you use SahrePoint list connector instead of Odata Feed connector?

Regards,
Lydia

[Anonymous]

For now, it is all:

It is loading about 1 hour ago and it does not end. If I press retry, the load restarts.

I'll wait, and if it ends at some point and I can see the detail I'll post again

In another wat, if i connect with the subsite using sharepoint list connector, i got this:

It seems like you can connect to the site but you will not find the lists

[Anonymous]

It has finished, here the screen:

[v-yuezhe-msft]

@Anonymous ,

When you use SharePoint list connetor, please make sure you enter correct URL. Also please translate error message in English.

https://Company.sharepoint.com/Site/Subsite

Regards,
Lydia

[DouweMeer]

@v-yuezhe-msft 

What has been the solution? I'm having the same problem. When I check Power Query and scroll down I can see them all without any errors, which are 181 records. But when I apply, it finds 1 error and only returns 80 lines. Also, the last line which is returned is empty. 

Message upon downloading