Forum Discussion

sujeesh's avatar
sujeesh
Helper I
6 years ago
Solved

How to connect Azure DevOps REST API in to power bi

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/releas...
Tutorial Requests
  • artemus's avatar
    artemus
    6 years ago

    = VSTS.Contents(<your url>)

  • artemus's avatar
    artemus
    6 years ago

    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"