Feb 26 2020 03:00 AM
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
Feb 26 2020 03:05 AM
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.
Feb 26 2020 03:17 AM
@Andrew Hodges , I want run time update not like in excel. Please suggest us is there any way we can.
Feb 26 2020 04:07 AM
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.