Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

SCCM Template Data Retention

Hi Everyone,

 

I am testing SCCM PBI template and i would like to know what does "Data Retention Days" really mean?

My requirement is that i would like my Target DB to have same data as the source DB regardless of the days/age. For e.g. my Source SCCM DB has 4 years of data. How do i ensure that i have all that data and it gets incrimenting or same as SCCM Source DB objects.


Below is the template that i am referring to  here
https://github.com/Microsoft/BusinessPlatformApps/tree/dev/Source/Apps/Microsoft/Released/Microsoft-... 

 

Regards

DataUpperCut

3 REPLIES 3
Anonymous
Not applicable

can someone help me understand the follow up questions i had on this? 

Anonymous
Not applicable

Hi @Anonymous ,

Data Retention Days specifies the amount of time that data generated bySystem Center Configuration Manager are kept in the site database. The date range is between1 and 365.

Best Regards

Anonymous
Not applicable

@Anonymous  i checked with my SCCM admin and he says that the source site DB (application DB) has around 4 years of data. Do you mean the target DB here? which is required to be created as part of this SCCM solution?

and that the target DB cannot import and stopre data of more than 365 days in the past? 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.