how to creates report tables in sharepoint list without using power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-1195430%22%20slang%3D%22en-US%22%3Ehow%20to%20creates%20report%20tables%20in%20sharepoint%20list%20without%20using%20power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1195430%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20in%20the%20sharepoint.%20Now%2C%20I%20would%20like%20to%20create%20some%20reports%20like%20charts%2C%20pivots%20without%20power%20BI.%20Can%20any%20one%20guide%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1195430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1195437%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20creates%20report%20tables%20in%20sharepoint%20list%20without%20using%20power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1195437%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568458%22%20target%3D%22_blank%22%3E%40Pradeep780%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20export%20to%20excel%20at%20the%20top%20of%20the%20list.%20Create%20pivot%20charts%20etc%20using%20excel%20with%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20the%20data%20is%20updated%20in%20SharePoint%20you%20can%20click%20refresh%20data%20in%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

hi,

 

I have a list in the sharepoint. Now, I would like to create some reports like charts, pivots without power BI. Can any one guide me.

 

thanks

3 Replies
Highlighted

Hi @Pradeep780 

 

Click export to excel at the top of the list. Create pivot charts etc using excel with the data.

 

When the data is updated in SharePoint you can click refresh data in excel. 

 

Highlighted

@Andrew Hodges , I want run time update not like in excel. Please suggest us is there any way we can.

Highlighted

@Pradeep780 

 

Do you mean real time update of data?  I think PowerBI would have to be used as Excel looks to not be able to do that (although I am no excel expert) ,  but I still don't know if data can be streamed from a SharePoint list top PowerBI for real time updates.

 

For sure you could code something to poll the SharePoint list every 10 seconds or so to get the data but you would be looking at some sort of custom dashboard.