Forum Discussion
Solved
Data Storage
Hi everyone! We are new to Power BI and would like to visualise our results with the option of a monthly update based on the new data fed in. The issue we are facing is the data being stored ...
Hi,
if i understood your problem, you need to create an excel file for each month and store them in a folder. In this folder each month you add a new file.
Then instead of loading the single file you load the folder.
PowerQuery would automatically "APPEND" data from all the Monthly Files to the same table. It becomes easier if you have a name pattern for the files like "SalesDate_YYYYMM.xlsx".
Hi, if you can provide some sample data it would be easier to evaluete if there is the necessity to modify excel files and in which direction