Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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 !!!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.