Microsoft Stream - Microsoft Automate/Flow - PowerBI - Reports

%3CLINGO-SUB%20id%3D%22lingo-sub-1589126%22%20slang%3D%22en-US%22%3EMicrosoft%20Stream%20-%20Microsoft%20Automate%2FFlow%20-%20PowerBI%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589126%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20people%3CBR%20%2F%3EI%20would%20like%20to%20make%20a%20report%20that%20is%20updated%20every%20day%2C%20at%20the%20end%20of%20the%20day.%3CBR%20%2F%3EThis%20report%20would%20contain%20all%20the%20videos%20created%20in%20the%20Stream.%3CBR%20%2F%3EI%20can%20generate%20this%20report%20through%20Audit%20within%20the%20Microsoft%20365%20Admin%20Panel.%3CBR%20%2F%3EBut%20I%20wanted%20to%20automate%20that%20process%2C%20and%20put%20it%20on%20PowerBI.%3CBR%20%2F%3EI%20have%20a%20little%20understanding%20of%20how%20Microsoft%20Automate%20%2F%20Flow%20works%20with%20PowerBI.%3CBR%20%2F%3EMy%20first%20problem%20is%20to%20retrieve%20(GET)%20this%20data%20using%20UnifiedAuditLog.%3CBR%20%2F%3EWhere%20we%20have%20a%20limit%20of%205000%20lines%20per%20GET%2C%20which%20can%20be%20increased%20to%2050%2C000%20if%20you%20purchase%20a%20better%20plan%20at%20Microsoft.%3CBR%20%2F%3EIn%20this%20GET%2C%20using%20UnifiedAuditLog%2C%20I%20can't%20filter%20only%20for%20videos%20created%20in%20Microsoft%20Stream%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20GET%20URL%20would%20be%3A%20%3CA%20href%3D%22https%3A%2F%2Foutlook.office365.com%2Fpsws%2Fservice.svc%2FUnifiedAuditLog%3FStartDate%3D%40date%26amp%3BEndDate%3D%40date%26amp%3BRecordType%3DMicrosoftStream%26amp%3BResultSize%3D5000%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foutlook.office365.com%2Fpsws%2Fservice.svc%2FUnifiedAuditLog%3FStartDate%3D%40date%26amp%3BEndDate%3D%40date%26amp%3BRecordType%3DMicrosoftStream%26amp%3BResultSize%3D5000%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIf%20there%20is%20a%20way%20to%20redeem%20only%20the%20videos%20created%20in%20this%20GET%2C%20it%20will%20save%20me.%3CBR%20%2F%3ESo%20I%20am%20not%20limited%20to%205000%20lines%2C%20because%20my%20flow%20of%20videos%20created%20per%20day%20is%20very%20low.%3CBR%20%2F%3EHowever%2C%20if%20you%20are%20going%20to%20do%20a%20GET%20taking%20all%20data%20from%20Microsoft%20Stream%2C%20then%20for%20sure%20this%20limit%20of%205000%20will%20be%20exceeded.%3CBR%20%2F%3EIf%20you%20can%20help%20me%2C%20thank%20you%20very%20much.%3C%2FP%3E%3CP%3ESorry%20for%20my%20English%2C%20I'm%20not%20fluent.%3C%2FP%3E%3CP%3EHugs%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello people
I would like to make a report that is updated every day, at the end of the day.
This report would contain all the videos created in the Stream.
I can generate this report through Audit within the Microsoft 365 Admin Panel.
But I wanted to automate that process, and put it on PowerBI.
I have a little understanding of how Microsoft Automate / Flow works with PowerBI.
My first problem is to retrieve (GET) this data using UnifiedAuditLog.
Where we have a limit of 5000 lines per GET, which can be increased to 50,000 if you purchase a better plan at Microsoft.
In this GET, using UnifiedAuditLog, I can't filter only for videos created in Microsoft Stream?


The GET URL would be: https://outlook.office365.com/psws/service.svc/UnifiedAuditLog?StartDate=@date&EndDate=@date&RecordT...


If there is a way to redeem only the videos created in this GET, it will save me.
So I am not limited to 5000 lines, because my flow of videos created per day is very low.
However, if you are going to do a GET taking all data from Microsoft Stream, then for sure this limit of 5000 will be exceeded.
If you can help me, thank you very much.

Sorry for my English, I'm not fluent.

Hugs

0 Replies