Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Team,
I have created one dashboard with Data column, User ID and user views.
This will refresh everyday but whenever data refreshed we are not storing old data
example:
We have last 30days data like June 13th to July 13th(refreshed on July 13th)
but if we refresh on July 14th data will change from June 14th to july 14th same way if we refresh on July 15th data will change from June 15th to July 15th.
we are not able to store June 13th data or previous data.
could you please help me how we can store old data going forward even if new day is added.
Thanks,
Balhemkan
Solved! Go to Solution.
@Balhemkan , there is DAX append method, You need to make sure you get new data only.
See if these blogs 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/
@Balhemkan , there is DAX append method, You need to make sure you get new data only.
See if these blogs 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/
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |