Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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 !!!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 6 | |
| 5 |