Forum Discussion
Using OData Feed : Azure DevOps Analytics: URL working in browser but not in PowerBI
I found that Organization that I was trying needed to be part of Active directory in order to use its organizational account to pull data.
My org is not part of AD. so I used below link to create personal accesstoken to login and pull data.
Thanks all for your help/
yeah that could be a bug but when I use organization name and Team project name for Organization B, it works in Power BI. it asks for credentials for OrgB and then pull the data.
as you know here is Odata URL, not sure if this URL needs to be modified except parameters.
https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItems? $select=WorkItemId,Title,WorkItemType,State,CreatedDate &$filter=startswith(Area/AreaPath,'{area path}') &$orderby=CreatedDate desc &$top=10
what do you suggest I should do now? 🙂
Hi Anonymous,
I'm unfortunately not familiar with Azure DevOps Analytics.
But I thought you couldn't get Organaton B's data into Power BI at all.
I found that Organization that I was trying needed to be part of Active directory in order to use its organizational account to pull data.
My org is not part of AD. so I used below link to create personal accesstoken to login and pull data.
Thanks all for your help/
oh I made a typo there. I meant it works when quering from a browser.
when I use organization name and Team project name for Organization B, it works in Browser only. it asks for credentials for OrgB and then pull the data.
It throws the error when tried with same URL in powerBI
Thanks for your time on this. I am reporting it as problem on DevOps community portal for devs.