Automatic retention policy for real-time data
Published: February 9, 2016
Updated: February 9, 2016
The automatic retention policy in the Power BI service is a query string parameter which enables a default retention policy to automatically clean up old data while keeping a constant flow of new data going into your dashboard. The first retention policy is called basic first in first out (FIFO). When enabled, data will collect in a table until it hits 200,000 rows. Once the data goes beyond 200,000 rows, the oldest rows will get dropped from the dataset. This will maintain between 200,000 and 210,000 rows of only the latest data.
The retention policies are enabled when you first create your datasets. All you need to do is add the “defaultRetentionPolicy” query parameter to your POST datasets call and set it equal to “basicFIFO”.
POST https://api.powerbi.com/v1.0/myorg/datasets?defaultRetentionPolicy={None | basicFIFO}