Auto Refreshing Excel Sheet. I need to refresh data weekly into 6 templates. Copy the url you see and paste that into the excel web query wizard and click go;
Once i've amended it, i then want to email it to some recipients. When you manually refresh, or schedule refresh, on the dataset, power bi connects directly to the external data sources to query for updated data it then loads into the dataset. You can use the excel as external data source, you can set refresh the excel per 1 minute.