I have Dashboard that get data from Excel from a SharePoint. Usually, when I Want to Refresh the Dashboard with latest set of data, I need to extract the data to Excel. Like from Intune device report, MECM device report. And manually copy the latest data in the Excel in the SharePoint.
Is there anyway to automate the process? From exporting data from other sources like Intune portal, MECM SQL server Reporting services. And automate to update the datasets with new datasets in the Excel in the sharepoint