Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have read the article https://community.powerbi.com/t5/Desktop/Adding-in-new-data-to-existing-data/td-p/202312 but I need some clarification.
I am creating a data model and I have historical data from the last 12 months. I will receive the new data in the same format every month. I do not need to refresh the historical data as it will not change. I want to append the new data to the historical to report on historical and new as one data source..
I created a new data source (folder) and it combines all the historical data files. My question comes on what to what to do next? Do I create another data source and filter on the newest file and then load into the model and append to the historical data? Or is there a way to use the existing connection (folder) I created but not load the historical data (But still be able to view the historcial data).
Looking for a best practice on adding new data without having to load the existing data that will not change.
Thanks
Jon
Solved! Go to Solution.
I would create a new folder for the new data. Set the original query to not update. Then you could append the results of each query.
Hi @jpt1228,
If my understanding is right, you need to Incremental Load data in Power Query like in this thread, right? If it is, the feature is unsupported, please see this ideas post and vote for it to get this feature in near future.
Best Regards,
Angelia
I would create a new folder for the new data. Set the original query to not update. Then you could append the results of each query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |