Forum Discussion
ADD NEW MONTHLY ROWS FROM EXCEL FILE
LucienF38 what is the purpose of having the new lines separate, if you just add it intot the file you have already it will automatically bring through all those rows when you refresh.
Hello LucienF38
When you say it is imported from Excel you mean, in PowerBI Desktop you went through Get Data > Excel > your file. So under Data source settings (Home > Edit Queries > Data Source Settings) you see the excel file.
If so, when you add new data to the excel file, when you hit refresh in PowerBI Desktop it will pull in the new data. If you publish the report to the service, you will need a gateway that has access to the location of the excel file but then you can configure the dataset to refresh automatically and the report will pull everything from the excel file.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
LucienF38 what is the purpose of having the new lines separate, if you just add it intot the file you have already it will automatically bring through all those rows when you refresh.
vanessafvg , Thank you, I didn't know refresh was working from an Excel file !
