06-26-2018 10:50 AM
We have an Excel file with a Data connection to a list in SharePoint Online. We would like to publish this Excel file to powerbi.com as an Excel file. We know how to do that. However, we would like the published Excel file to regularly and automatically update the data in the Excel file based on the data in the SharePoint list. We see the option to trigger the refresh manually. Is there a way to refresh automatically?
06-26-2018 02:31 PM
I'm not sure if that can be done with Excel. You might be able to use a product called Power Update?
Or you could put the SharePoint list into Power BI as an imported dataset. Which you could then refresh. And your end users could connect to the dataset using the analyze in Excel option?
"Proud to be a Datanaut!"