Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 pro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

What type of authentication (or which account) do you use in the browser?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    So basically when I open the URL in browser it prompts me to put credentials for that project account as shown below. 

     

     

    Upon login into account, it shows json reply. 

    btw, I am sending you my Odata URL in private message to you if you wanna paste that in browser

     

    Thanks for your time and helping me. 

     

     

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi Anonymous 

       

      I am getting the same error.
      I think there is a bug in the WWW-Authentication header of the OData Feed Service from DevOps Analytics.

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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? 🙂