Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create Insights from identical Excel Sheets from a SharePoint Library

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

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

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
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.