Stream usage logs

%3CLINGO-SUB%20id%3D%22lingo-sub-756285%22%20slang%3D%22en-US%22%3EStream%20usage%20logs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756285%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F114%22%20target%3D%22_blank%22%3E%40Marc%20Mroz%3C%2FA%3E%26nbsp%3BI%20am%20trying%20to%20use%20the%20unified%20audit%20logs%20to%20get%20Microsoft%20Stream%20usage%20which%20I%20am%20then%20using%20Power%20BI%20to%20create%20visualisations.%26nbsp%3B%20I%20have%20an%20issue%20where%20the%20information%20in%20the%20logs%20is%20not%20matching%20up%20with%20the%20information%20in%20the%20Stream%20user%20interface.%26nbsp%3B%20I%20have%20as%20an%20example%20one%20video%20where%20i%20have%20276%20views%20showing%20in%20stream%20but%20the%20logs%20have%20348%20entries%20for%20views%20for%20that%20video.%26nbsp%3B%20I%20wander%20if%20there%20is%20a%20simple%20explanation%20for%20this%20and%20if%20so%20how%20I%20would%20filter%20any%20unwanted%20results%20out%3F%26nbsp%3B%20THe%20only%20thing%20i%20can%20think%20of%20is%20the%20logs%20may%20capture%20sombody%20repeatedly%20refreshing%20the%20video%20page%20and%20count%20each%20one%20as%20a%20view%20but%20the%20views%20on%20the%20Stream%20page%20somehow%20filters%20this%20out.%26nbsp%3B%20WIthout%20knowing%20i%20cannot%20really%20use%20the%20logs%20to%20give%20accurate%20usage%20analysis%20to%20the%20business%20as%20the%20mismatch%20would%20immediatly%20create%20an%20issue%20of%20trusting%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Chetan_M
New Contributor

HI @Marc Mroz I am trying to use the unified audit logs to get Microsoft Stream usage which I am then using Power BI to create visualisations.  I have an issue where the information in the logs is not matching up with the information in the Stream user interface.  I have as an example one video where i have 276 views showing in stream but the logs have 348 entries for views for that video.  I wander if there is a simple explanation for this and if so how I would filter any unwanted results out?  THe only thing i can think of is the logs may capture sombody repeatedly refreshing the video page and count each one as a view but the views on the Stream page somehow filters this out.  WIthout knowing i cannot really use the logs to give accurate usage analysis to the business as the mismatch would immediatly create an issue of trusting the data.