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 from the Time Log Summary into a csv, store it in sharepoint and then it will load into power bi.

 

Being "constructively lazy", i would like to know if it is possible (and how) to load into power bi from the azure extension area directly os that it will update during the scheduled refreshes. 

 

"https://{organisation).extmgmt.visualstudio.com/_apis/ExtensionManagement/InstalledExtensions/timelog/time-logging-extension/Data/Scopes/Default/Current/Collections/TimeLogData/Documents/" 

The link when i look through chrome seems to come back immediately with all the data. I cant figure out how to bring that query into my power query to get the same data (just beggining the journey into the wonders of Power BI).

 

Need Help

2 Replies

  • 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"