Forum Discussion
Using OData Feed : Azure DevOps Analytics: URL working in browser but not in PowerBI
I am trying to connect to DevOps Analytics using OData Feed Data source from Power BI desktop.
It gives me below error :
I think its related to some kind of configuration / permission in project or user configuration. Not sure what is the correct configuration.
If I try this URL in browser, it give me json reply back which is correct.
From Power BI only it sends me error back.
note:
I am logged in with OrgA credentials on PowerBI, and if I try to connected OrgA projects it works fine.
But If I try to connect to OrgB project while logged in with OrgA, it wont work.
I also made sure that Analytics View is enabled for organization level.
I am trying to follow the exercise from this Article but using my own project to pull data from Azure DevOps Analytics.
Your help is appreciated. Thanks
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/
10 Replies
Hi Anonymous ,
Maybe a temporary problem? Look at that?
Does the OrgA account have access rights to OrgB?
Do you have an OrgB account that you can use to access the OrgB project?Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.Hello mwegener ,
OrgA account does not have acess right to OrgB.
Actually they are both separate organizations but I am using it to just pull the data to setup my OData query and testing.
I am owner role for OrgB project and have account for OrgB project.
For OrgB project, I made sure Analytics View is enabled, can be accessed in Browser, OData URL gives Json reply with data back in browser.
one more thing, If I choose Azure DevOps(Beta) connector from Data source options in PowerBI (instead of ODataFeeds), it works fine and pulls the data. Just giving problems when using ODataFeeds.
OrgA works just fine.
Hi Anonymous ,
What type of authentication (or which account) do you use in the browser?
