Solved: Re: How to connect Azure DevOps REST API in to pow... - Page 2

sujeesh · ‎01-09-2020

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

artemus · ‎01-09-2020

= VSTS.Contents(<your url>)

View solution in original post

artemus · ‎01-09-2020

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

artemus · ‎01-09-2020

Add this line as your next step:

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

How to connect Azure DevOps REST API in to power bi

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024