Most demonstrations of using as an excel sheet as a datasource for Power BI will assume the excel sheet is locally stored. This is what happens when you click Get Data and Excel in Power BI desktop. Eventually you will want to have this auto refreshing and in order to do this you could install…