Create Insights from identical Excel Sheets from a SharePoint Library

[Anonymous]

Hello Guys, 

i hope you can help me with my specific scenario which we use in our Company. 

The Scenario: 

Our IT Department work sometimes on the weekend. If that happened they have to fill out an given xcel template with the time and then their salary is calculated in it. They upload it to a Sharepoint Libary and then the File has to be approved by their Chef. 

The Template is locked so the layout of each Doc is identical. 

Now I want to summarize all the different (and approved) Files and create a Report with them in PowerBi, I also didnt find the field in which the Approval state was saved in my Query (SharePoint Folder -> Filter by Library Name -> [List with all .xls Files]

But till now I didnt realy get the correct way to do this. 

The reason why I can't use a Sharepoint List is because of our calculations in the Sheets.

Maybe you can help me a bit with the Query

Thank you for your help and with best regards

[Anonymous]

Hi  @Anonymous ,

For your questions, check out these links:

How to import an Excel spreadsheet to a SharePoint custom list

https://sharepointmaven.com/how-to-import-an-excel-spreadsheet-to-a-sharepoint-custom-list/

Fix most common issues with SharePoint Import Spreadsheet functionality：

https://sharepoint.handsontek.net/2018/01/03/fix-most-common-issues-with-sharepoint-import-spreadsheet-functionality/

Importing And Exporting Data From SharePoint And Excel：

https://www.howtoexcel.org/tutorials/sharepoint-and-excel/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear. see if this can help https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/