Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hello All,
Would require the best way to manage data loading.
I have got a model where i need to load data monthly and the data does not have the date,but then it would be possible to get the
date stamp from the sytem when loading so if i load it in april 2021 i could set a column with data for date to april.
The data is in an excel in a folder
Now if i want to load for next month MAY and the coming months how do i go about and append this data to the already existing April data.
Name of the files would be the same.The files would come into the folder in the mid of month.
Thanks
Solved! Go to Solution.
@Anonymous , DAx append is a method that can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
for load timestamp, refer
@Anonymous , DAx append is a method that can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
for load timestamp, refer
@amitchandak Thanks a lot for the Good Read.I just know that this forum has very fine people with lot of knowledge and dont hesitate to share.thanks
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 54 | |
| 42 | |
| 30 | |
| 24 |