cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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)
Version13.0.4759.170

 

 

 

 
 
 
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
 
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!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors