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
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
jdbuchanan71 , Thank you for the second question :)