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".
You have various options with PowerBI for the updates (based on the license you have - Pro or Premium).
You could use Data Alerts or your users can use Monthly Subscription to the report or you can use APIs to push the Reports to your users.