Stream Analytics Feed/Purging historic data

Gregs138 — Wed, 28 Mar 2018 17:51:37 GMT

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)

Version13.0.4759.170

Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net

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)

Version13.0.4759.170

Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net

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!

Re: Stream Analytics Feed/Purging historic data

JoelMills — Mon, 26 Apr 2021 23:30:07 GMT

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.

topic Re: Stream Analytics Feed/Purging historic data in Developer

Stream Analytics Feed/Purging historic data

Re: Stream Analytics Feed/Purging historic data