Delete or reset a real-time dataset

[khaledhikmat]

Hello, given a real-time dataset created by a real-time stream (API or Stream Analytic), how do I reset it or clear its entries? I want to pump test data, build the visuals, reset the data and make it available for the real stuff. Thanks.

Regards

[alexsroussi]

I think I found a trick for this one (if you're talking about streaming dataset). You can disable Historic data analysis and re-enable it.

It looks like disabling clears the stored data.

[Felix_Schulte]

Can you do this vis REST API?

[tdratler]

This worked for me. Turn off history, save, turn on history, save. Then refresh the displays.

Thank you!

[alexsroussi]

I think I found a trick for this one (if you're talking about streaming dataset). You can disable Historic data analysis and re-enable it.

It looks like disabling clears the stored data.

[sirui_sun · Accepted solution]

Hello!

If you've created a real-time dataset and you didn't check the "Enable historic data analysis" option, then there is no need to manually clear its entries, since Power BI is not storing anything.

If you've created a real-time dataset either by checking the "historic data analysis" option, or via an Azure Stream Analytics output, you can delete its rows using our REST API. You can start with our documentation here, let us know if you have any questions!

[iDS]

Hi sirui_sun 

I am not clear on the proposed solution.

I have Stream analytics job that push streaming data into Power BI .

I want to be able to reset \ clear the dashboard that feeds off the streaming dataset.

Fyi The Dashboard report Event attendance and Sale info ... I want to be able to reset the dashboard the following day automatically .Appreciate your assistance