excel - power bi
In Power bi , I want to pull data from Excel, but I want it to be interactive so that if any change occurs in the data in Excel, it changes automatically in Power BI. What is the correct way to do that, please?
By simply refreshing the dataset, given that the Excel file has got the exact same name, is saved in the exact same location and has the exact amount of columns. Otherwise you need to manually edit it inside Power Query every time you want to parse a new Excel file.