Deleting or archiving mechanism for real time data come from Azure Stream Analytics

[AllanXu]

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,

[tesmerr]

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

REFERENCE: https://social.msdn.microsoft.com/Forums/en-US/162605e8-68b2-4837-b2c5-56506c927600/power-bi-data-re...