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 Anonymous ,
The closest you will get to native data warehousing with Power Query/Power BI is incremental refresh:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
This comes with its own significant caveats, such as never being able to download your accumulated data, but it may be just what your looking for in your scenario.
Beyond that, for any production-level reporting, you will need to set up an actual data warehouse to collect and store this historical information.
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