Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gregs138
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!
1 REPLY 1
JoelMills
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.