Solved: Sharepoint folder not loading data completely

user900 · ‎08-22-2023

I pulled all the data files from a SPO folder by selecting the folder path and using the double arrows on the content field. When I look at the combined data, some of the days show all the rows as null. There are 29 files in total, which I receive daily. Each has approx 10,000 rows. I have confirmed all these files contain the same column headers as well as format type. Does anyone know how to fix this?

Thanks,

~User 900

JoeBarry · ‎08-22-2023

Hi @user900

It could be that some rows are blank, this can happen when importing Excels from SharePoint. For testing, filter out the blanks, maybe on the Primary key column (Usally a unique ID column), then load the data into the report. In the table view, check how many Rows you have. If it is around 290K then the blanks in the Excel's was the issue.

Another solution you could try is to import again, but this time only have one file in the folder, make all the relevant changes to the file and when you are finished, add the rest of the files to the folder

Thanks

Joe

View solution in original post

JoeBarry · ‎08-22-2023

Hi @user900

It could be that some rows are blank, this can happen when importing Excels from SharePoint. For testing, filter out the blanks, maybe on the Primary key column (Usally a unique ID column), then load the data into the report. In the table view, check how many Rows you have. If it is around 290K then the blanks in the Excel's was the issue.

Another solution you could try is to import again, but this time only have one file in the folder, make all the relevant changes to the file and when you are finished, add the rest of the files to the folder

Thanks

Joe