Missing Records From SharePoint File

[NinjaL]

I imported an Excel file from SharePoint and it imported sucessfully with no errors. When I try to view the data in Power Query, I'm only seeing 98 records out of 330k. Any ideas to help troubleshoot as to why I'm only seeing a limited amount of records? I tried as importing as a Web connection and SharePoint folder connection and got the same results. 

[v-piga-msft]

Hi @NinjaL ,

If I understand your scenario correctly that when you get data from the excel file in SharePoint, you could only see the limit data in right page of the Navigator?

If that is your case, I could reproduce your scenario.

In my case, I have more than1k rows in the excel file but now i cannot see the completed rows in the preview page.

Actually, if you load or edit the data in query edit, it will load all of the rows of the excel file.

In addition, please check if you have installed the latest version of Power BI Desktop Version: 2.66.5376.1681 64-bit (February 2019).

If you still need help, please share some screenshots to describe your scenario better so that we could help further on it.

Best  Regards,

Cherry

[NinjaL]

Thanks for the feedback @v-piga-msft. 

When I go to Edit Query, I only see 96 records out of 33,430.

When I scroll down (in hopes to seeing more rows), I don't get more rows.

In addition, I am using the latest version of PowerBI Desktop.

[v-piga-msft]

Hi @NinjaL ,

That's really strange. I cannot reproduce your issue in my site with connecting with Web connector.

Please check if your file still contains 330k rows in SharePoint firstly.

If it really have 330k records in SharePoint, please click Refresh in Query Editor to check if you could see all records.

In addition, if it is convenient, could you have a test with other file which contains more than 100 records to check will it still have this issue.

Best Regards,

Cherry

[NinjaL · Accepted solution]

I did confirm that the file in SharePoint does contain at 330k rows. I did some test by pulling other files with more than 1000 rows (but not as much as the one file I'm having trouble with) from the SharePoint and they worked out fine.  I did an additional test by uploading a copy of the file I'm having trouble with to my OneDrive and reference OneDrive location as the data source and it pulled all the data. So I reuploaded the Excel file back to SharePoint and refernce via Web Data Source and it's working now. Thanks for you all your help.