Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am querying for Azure DevOps data using web API and trying to expand related remote links. I know the web API url which is
https://dev.azure.com/fabrikam/_apis/wit/workitems?ids=297&$expand=relations&api-version=6.0
I need the above url in Power query format so that it can refresh on PBI services which is like below.
let Source1 = (Id as text) =>
let
Source = VSTS.Contents("https://dev.azure.com/fabrikam/_apis/wit/workitems",
[
Query = [ids=Id]
]
),
#"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
#"Imported JSON"
in
Source1
The help I need is to add expand part from the above web API url in the Power query. I am new to using APIs.
Thanks in advance!!!
Solved! Go to Solution.
Have you tried using a Query record of [ids=Id, #"$expand"="relations"] ?
(The #"..." syntax is M's way of escaping identifier names, which can be used to include characters that aren't normally allowed.)
Have you tried using a Query record of [ids=Id, #"$expand"="relations"] ?
(The #"..." syntax is M's way of escaping identifier names, which can be used to include characters that aren't normally allowed.)
Yes, that worked.
I was calling the expand outside the "[ ]", which was my mistake.
Thank you !!!