Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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).
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"
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.