Retrieve Microsoft Stream videos statistics

[DataVitalizer]

Hi Community,

I have tens of videos in my Microsoft stream based on which I want to created a report to illustrate number of videos, video lenght, and views.

Does anyone of you have an idea?

Thank you in advance. 

[v-yangliu-msft · Accepted solution]

Hi  @DataVitalizer ,

You may try to use the Power query web connector (actually use the M function Web.Contents) to connect to the microsoft stream video website under your personal account, and check if there's any chance to get any related data (regrading the token used to access the website, you may also need to capture the network trace for it and put it into the request headers).

Power Query Web connector - Power Query | Microsoft Learn

Web.Contents - PowerQuery M | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.