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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
44,447 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
44,437 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
44,349 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
42,311 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
35,183 Views
0
artemus
Microsoft Employee
Microsoft Employee

‎01-09-2020 08:32 AM

= VSTS.Contents(<your url>)

Message 2 of 27
44,438 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,039 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
31,767 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
29,194 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

View All
Top Solution Authors
View All