Forum Discussion
Archiving data to create trends
Possibly. It's a bit of a tricky process.
Unfortunately, this is the only native data retention support directly connected to PowerBI.
You could look into pushing your daily data into a small SQL server using Power Automate, or even by using Power Query/R, something like this:
Ruth @ Curbal https://www.youtube.com/watch?v=ANIZkTZO3eU
Other than that, it's a proper data warehouse and ETL process you need to go for.
Pete
Hi BA_Pete,
Thank you for your reply, however, I have tried incremental refresh. But it didn't give me the result I wanted. Maybe I haven't set up the incremental refresh correctly.
Twan
Possibly. It's a bit of a tricky process.
Unfortunately, this is the only native data retention support directly connected to PowerBI.
You could look into pushing your daily data into a small SQL server using Power Automate, or even by using Power Query/R, something like this:
Ruth @ Curbal https://www.youtube.com/watch?v=ANIZkTZO3eU
Other than that, it's a proper data warehouse and ETL process you need to go for.
Pete