getting azure data

[Anonymous]

Can anyone please help me connect to Azure devops other than by Azure Devops beta.

I want to be able to refresh my azure devops(Kanban board) data in Power BI Services which using Azure devops deta is not possible.

I have tried using Odata but I dont get all of my data as  I get in Azure Devops beta

I also tried Relative Path method by Chris Webb but I have been unsuccessful in it.

 I tried writing

let
Url = Web.Contents("https://dev.azure.com/Organizationname",
[
RelativePath="projectname"
]
)

in
Url

but its not working.

So can anyone please help me find the solution . I want all the Workitems, Bugs, Tasks, User Stories tables in it.

Regards,

[v-juanli-msft]

Hi @Anonymous 

I can reproduce your problem.

As tested according to this document, it is possible to refresh in Power BI Service.

Go to Setting, find the dataset, go to edit credential,

select "Oauth2" and sign in with the same credential as used in Power BI Desktop,

then you could set a schedule refresh or on demand refresh.

Best Regards

Maggie