Forum Discussion

Peter_Yaacoub's avatar
Peter_Yaacoub
Frequent Visitor
4 years ago
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 ...
Data Protection
  • serpiva64's avatar
    serpiva64
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    4 years ago

    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". 

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

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.

Peter_Yaacoub's avatar
Peter_Yaacoub
Frequent Visitor
4 years ago

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". 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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".