Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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 !!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
6 | |
6 | |
6 |