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"

     

artemus's avatar
artemus
Microsoft Employee
4 years ago

You are probably using a ZIP64 arcieve, which I didn't implement here.

Stefano333's avatar
Stefano333
Regular Visitor
2 years ago

Hi Artemus,

it would be great if you could also give the whole world a 64-bit unzip function 🙂 !! 
In my case, downloading data from uncompressed eurostat databases becomes a huge problem (very slow).
On the other hand, Eurostat returns zip files in 64bit at the speed of light.
many thanks if you can work magic... !