Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
When Azure Stream Analytics pushes real-time data into a dataset, for how long the data will stay in the dataset?
What is the mechanism to delete the old data streamed a few months ago?
Thank you,
Was searching for the same thing - and found it - so for completeness for others -
Stream Analytics uses the default PowerBI data retention policy, which is 200,000 rows. After that, data is flushed out using FIFO.
If you want to remove data on your own, you can use the Power BI REST APIs to clear the rows of a table: http://docs.powerbi.apiary.io/#reference/datasets/table-rows/clear-the-rows-in-a-table