Forum Discussion

Dave_Petrie's avatar
Dave_Petrie
New Member
5 years ago

Extracting data from Time Log extension in Azure DevOps.

I am using the Time Log extension to capture times within stories and tasks in Azure DevOps. I am extracting the ADO information into power BI. I am manually dumping the Time Log information fro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I can use the Time Log extension data with this "Advanced Editor" code:

let
    Source = VSTS.Contents("https://extmgmt.dev.azure.com/[MyCompany]/_apis/ExtensionManagement/InstalledExtensions/TimeLog/time-logging-extension/Data/Scopes/Default/Current/Collections/TimeLogData/Documents"),
    #"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
    #"Imported JSON"