Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone,
I'm currently using the ReportServer database to build a monitoring dashboard for my SSRS reports. Everything is working fine, but I’ve noticed that the available data only covers the last 60 days.
For better trend analysis, I need to retain data for a longer period (e.g. 90 days or more).
Does anyone know how I can increase the data retention period in the ReportServer database, so that my dashboard can show a broader timeline?
Any help would be greatly appreciated! 🙏
Thanks in advance
Solved! Go to Solution.
You can set this by connecting to the PBIRS instance using Management Studio Connect to Power BI Report Server with SSMS | Under the kover of business intelligence and then setting it under the logging tab
Dear d_gosbell,
Thank you for your help. it was exactly what I needed.🙏🌹
You can set this by connecting to the PBIRS instance using Management Studio Connect to Power BI Report Server with SSMS | Under the kover of business intelligence and then setting it under the logging tab
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 15 | |
| 7 | |
| 5 | |
| 5 | |
| 4 |