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 have an extension in Azure Devops that allows HTTP GET on https://{organisation}.extmgmt.visualstudio.com/_apis/ExtensionManagement/InstalledExtensions/timelog/time-logging-extension/Data/Scopes/Default/Current/Collections/TimeLogData/Documents/ and it returns JSON data. This works fine in browser but I can't get it to load using 'Web' data source in Power Query/BI. I'm stuck at the authentication page.
let
Source = Web.Contents("https://{org}.extmgmt.visualstudio.com/_apis/ExtensionManagement/InstalledExtensions/timelog/time-logging-extension/Data/Scopes/Default/Current/Collections/TimeLogData/Documents/", [Headers=[Accept="application/json", Authorization="Basic cXZvMjNhNHhneGNza29kN203NTQ1cTBuFczbWdvbGlhdXFxYWpnMzVqa2hnZjNlc2FmcQ=="]]),
Result = Json.Document(Source)
in
Result
Can you advise what kind of authentication mechanism (and how it) can be used to get this resultset through programs like PowerQuery editor? I just want the output JSON to become a data source for Power BI.
Thanks!
Solved! Go to Solution.
Never mind, I got the resultset with this:
let
Source = VSTS.Contents("https://{org}.extmgmt.visualstudio.com/_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"
Thanks!
Never mind, I got the resultset with this:
let
Source = VSTS.Contents("https://{org}.extmgmt.visualstudio.com/_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"
Thanks!
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.