Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
sujeesh
Helper I
Helper I

How to connect Azure DevOps REST API in to power bi

‎01-09-2020 08:29 AM

Hi,

I am new to this power bi. Can someone please tell me how to connect the Azure Devops REST API into the power bi.

The API I am trying to connect is "https://vsrm.dev.azure.com/****/_apis/release/definitions?api-version=5.1".

 

Thanks & Regards,

Sujeesh

Labels:
Message 1 of 27
52,723 Views
0
2 ACCEPTED SOLUTIONS
artemus
Microsoft Employee
Microsoft Employee

‎01-09-2020 08:32 AM

= VSTS.Contents(<your url>)

View solution in original post

Message 2 of 27
52,713 Views
artemus
Microsoft Employee
Microsoft Employee
In response to sujeesh

‎01-09-2020 12:25 PM

Oh, that isn't zip I think. It should be JSON. Just apply the line I gave in the previous post of the zip function. The zip function is useful if you want to download a bunch of files out of git. I did this myself once to do a git blame summary

 

This is what your query should look like:

 

 

let
    Source = VSTS.Contents("https://vsrm.dev.azure.com/fe-tfs/_apis/release/definitions?api-version=5.1"),
    #"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
    #"Imported JSON"

 

View solution in original post

Message 8 of 27
52,625 Views
26 REPLIES 26
sujeesh
Helper I
Helper I
In response to artemus

‎01-09-2020 08:19 PM

Thank you my friend. It worked😀

Message 9 of 27
43,269 Views
0
brashbala
New Member
In response to sujeesh

‎10-20-2020 08:44 PM

Hi Sujeesh,

I am also facing a similar kind of issue. I believe it's a syntax error. 

 

Expression.syntaxError: Token Eof expected

 

= VSTS.Contents("https://dev.azure.com/****/*****/***** Pod/_apis/work/teamsettings/iterations/*******/capacities?api-version=6.0"),
#"Import Json" = Table.FromRecords(Json.Document(Source,65001)[value])
In
#"Import Json"

 

 

Message 10 of 27
36,141 Views
0
artemus
Microsoft Employee
Microsoft Employee

‎01-09-2020 08:32 AM

= VSTS.Contents(<your url>)

Message 2 of 27
52,714 Views
sujeesh
Helper I
Helper I
In response to artemus

‎01-09-2020 08:57 AM

Thank you for clarifying my doubts. It worked

I got the result as a JSON file. Can you tell me how to convert this JSON file as a table so that I can use this data in my chart

 
Message 3 of 27
34,997 Views
0
sujeesh
Helper I
Helper I
In response to sujeesh

‎01-09-2020 08:59 AM

Please find the screenshotPower bi.png

Message 4 of 27
32,725 Views
0
artemus
Microsoft Employee
Microsoft Employee
In response to sujeesh

‎01-09-2020 09:26 AM

Add this line as your next step:

= Table.FromRecords(Json.Document(Source,65001)[value])

Message 5 of 27
30,152 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All