Extracting data from Time Log extension in Azure DevOps.

[Dave_Petrie]

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/timelo...

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).

[Anonymous]

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"

[v-alq-msft]

Hi, @Dave_Petrie 

I'd like to suggest you refer to the following link to see if it helps.

Connect to Analytics with Power BI Data Connector 

Best Regards

Allan

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