HowTo: import data from devops (VSTS) git repo

[artemus]

If you ever wanted to pull items from your Devops (VSTS) repo here is how:

// Branch
"master" meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]

// MytableFromGit
let
    Source = VSTS.AccountContents("https://dev.azure.com/{organization}/{project}/_apis/git/repositories/{repo}/items?path={path}&version=" & Branch & "&download=true&api-version=5.0")
in
    Source

Replace the following with your values:

{organization}

{project}

{repo}

{path}

You can edit the Branch parameter to a different branch for testing

After you load the query, you will need to "Open As" into csv/json/xml

VSTS API link: https://docs.microsoft.com/en-us/rest/api/azure/devops/git/items/get?view=azure-devops-rest-5.0

[kva-sell]

This is great! Thanks for sharing

[artemus · Accepted solution]

---

@artemus wrote:

If you ever wanted to pull items from your Devops (VSTS) repo here is how:

// Branch
"master" meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]

// MytableFromGit
let
    Source = VSTS.AccountContents("https://dev.azure.com/{organization}/{project}/_apis/git/repositories/{repo}/items?path={path}&version=" & Branch & "&download=true&api-version=5.0")
in
    Source

Replace the following with your values:

{organization}

{project}

{repo}

{path}

You can edit the Branch parameter to a different branch for testing

After you load the query, you will need to "Open As" into csv/json/xml

VSTS API link: https://docs.microsoft.com/en-us/rest/api/azure/devops/git/items/get?view=azure-devops-rest-5.0

---

[Anonymous]

im getting a token Eof  error in "let"

[v-juanli-msft]

Hi @artemus 

Thanks for sharing your knowledge and experience importing data from devops (VSTS) git repo with Power BI.

To make your solution found by more people and more quickly,

i would suggest you to reply to yourself with your original post content and mark your answer as a solution.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.