I’m working with a client who will be getting weekly data files in the exact same structure with new records for the past week, and we’d like to create a way in which I do the initial setup of the data model, after which we can simply add new data files to the same folder (same data structure as the previous fact tables) so the new records from each dataset are added to the existing master fact table sitting in the pbix data model.
Is it possible to set up a data sourcing operation in Power BI in which I can drop new CSV files (with new records for a fact table) into a shared folder on the cloud (onedrive, google drive, etc.) and have Power BI automatically source that file, pick up the new records from those new files, and append them to existing fact table already set up in the power bi datamodel? I’m sure this can be done with some additional coding, but I’m hoping there’s an out of the box method someone can share with me.
I understand this can be done in just a few minutes by a power bi developer using power query/append, OR by copy/pasting the new records to the same source file, however I’m hoping there’s an easier way.
If there are other ways to streamline this process of adding regular new data without manually sourcing the new file and running an append, please let me know!
@BrianJ any ideas?