Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 SourceReplace 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
This is great! Thanks for sharing
@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 SourceReplace 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
im getting a token Eof error in "let"
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.