Timespan/duration values in KQL, Power Query and Power BI
In many scenarios event durations are very important. They can be measured in days or in milliseconds and anything in between. In real time analytics it is especially important. In this article I'll describe how such values are treated in KQL and what happens to them when they are brought into Power Query and eventually to Power BI. Finally, I'll provide my recommendation for treating these values in Power BI.
Accessing video length via JSON
I've recently migrated my videos from Stream (Classic) to Stream (on SharePoint) I'm now using custom formatting to make the document library appear more like the search results on YouTube, for example -- large thumbnail, title and description. I'd like to add the video length as well. I can see the Duration field in each video's properties (along with Dimensions, Type etc.), but how do I access the value via JSON?
