Forum Discussion

sujeesh's avatar
sujeesh
Helper I
6 years ago

How to load full list of data from the Azure Devops API

Hi,

I am new to power bi. I am trying to connect Azure DevOps REST API with the power bi. On loading the data I get only the first 50 sets of data. Can some please tell me what should I do to load the full list of data

 

The URL I am using is 

https://vsrm.dev.azure.com/fe-tfs/Advisory products/_apis/Release/releases?api-version=5.1-preview.6

 

 and the query I am using is

let
Source = VSTS.Contents("https://vsrm.dev.azure.com/fe-tfs/Advisory products/_apis/Release/releases?api-version=5.1-preview.6"),
ZIPFile = Table.FromRecords(Json.Document(Source,65001)[value]),
#"Expanded projectReference" = Table.ExpandRecordColumn(ZIPFile, "projectReference", {"id", "name"}, {"projectReference.id", "projectReference.name"})
in
#"Expanded projectReference"

 

Thanks & Regards,

Sujeesh

 

Tutorial Requests

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi sujeesh ,

    I am not clear about your dataset, when you use below M code, what will you get ?

     

    let
Source = VSTS.Contents("https://vsrm.dev.azure.com/fe-tfs/Advisory products/_apis/Release/releases?api-version=5.1-preview.6"),
ZIPFile = Table.FromRecords(Json.Document(Source,65001)[value])
in
ZIPFile

     

    You said that it will load first 50 sets of data, did you mean when selection preview or in report preview? The preview shown for any selected views in the navigator can be truncated depending on the number of fields selected and the size of the dataset. The data is truncated only for the preview and won't impact the full data refresh. You could refer to Connect to Analytics with Power BI Data Connector  for details.

    Is there any other records or lists in Power Query which could be expanded?

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.