Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Stream Analytics Feed/Purging historic data

Hi all, running into a situation with stream dashboard using Azure stream analytics as a source.  Stream is working fine, but I need a way to limit the time window of the stream.  The end viewer does not need to see the stream for more than say an hour window because the data is archived as well through a seperate stream if they want to go do a further analysis.


I have tried going into the dataset settings  and setting the option "Historic Data Anlysis" to off.  This does a one time purge of the data.  However, it also results in two error conditions:


1. My visual on the report breaks, and throws and error:


"Something is wrong with one or more fields."  Details:
Activity ID23995aa0-6303-4133-b4ca-e6a133ddb51e
Request ID95f742aa-c0c5-f51e-9c6f-c1e7cd1c713e
Correlation ID2495b704-f40f-682d-a078-181341d2aec8
TimeWed Mar 28 2018 10:45:34 GMT-0700 (Pacific Daylight Time)




2. The second issue is that the ability to purge the data set now seems entirely lost.  I can no longer switch the "Historic Data Analysis" button to the on or off position, it just keeps throwing an error:


"The data could not be updated.  Please try again later or contact support." The detail of the error contains the following:


Activity ID23995aa0-6303-4133-b4ca-e6a133ddb51e
Request ID65fc02c2-e86e-9af0-29b8-5187457201b7
Correlation ID5c820a0d-b138-7d67-49a9-eb588172a107
Status code404
TimeWed Mar 28 2018 10:46:37 GMT-0700 (Pacific Daylight Time)
Oddly enough, the dashboard tile is still streaming just fine-it is only the report that is broken.  If I look at the tile on the report it says:
At this point, the only way for me to reset is to delete the data set completely, and to rebuild the report and dashboard.  Any help much appreciated!
New Member

I have the same issue... it just broke after I added some extra fields to the data set that match the SP list I am pulling from.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors