Forum Discussion
Data Storage
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 Serpiva,
Thanks for your response. Above is a screenshot of a table I am preparing from the unstructured excel files. I understand it needs to be in flat format before being loaded to Power Bi. I am not sure how to take it from here so monthly data is added resulting in a dashboard update.
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.
Hi Serpiva,
Thanks a lot for the solution I will definitely try this. I was wondering if it's possible to create one table and adding the new data to it through the "Append Queries".
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".