Forum Discussion

ryszardre's avatar
ryszardre
Frequent Visitor
4 years ago
Solved

How to access Azure DevOps in Power BI Service dataflows using API Token?

Hi,    I would like to ask you how to access Azure DevOps tables in Power BI Service? I would like to create a dataflow using API Token as a basic credentials but I cannot click "Connect" without e...
Dataflow
Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    I don't think just having full access solves it. I'll check my access later and come back if I don't have them.
    -----I'm back. Checking my configuration
    I have a visual studio license. I do have the prerequisites

    Analytics view turned on

    Projects with view analytics

    Finally I'm part of a group at organization level permission (the group has "allow" for all permissions):

    I hope some of that helps to connect. If this continue like that, try getting a single table, like "Projects". Add that word at the end of the URL. 

ibarrau's avatar
ibarrau
Super User
4 years ago

Hi. In order to connect DevOps via OData you need a Personal Access Token from your Personal Settings in dev.azure

Then configure your personal access and permission.

 

Once you have that token you can write the url and complete the basic auth like:
username: AzureAD email or blank

password: token key generated before.

 

If dataflows is not letting you continue with blank, just add your email. That should let you get the data if you have permission.

I hope that helps,

  • ryszardre's avatar
    ryszardre
    Frequent Visitor
    4 years ago

    Hi ibbarau, 

     

    Thanks for your prompt response. I gennerated new token with full access and used Azure AD email as a username but the only result I get is still the same screen:

    There is not even an error message. 

     

    It is also not possible to left username blank because then "Connect" button is not active:

     

    Thanks again for your further help!

    collinq - there is no Azure Dev Ops connector in Power BI service.

    • ibarrau's avatar
      ibarrau
      Super User
      4 years ago

      That's weird. I have just tried this and it worked. Can you show us the whole url for the OData just hidding the company name?

      Also, be sure that the password is correct. My key from the personal api access is a lot longer, something like: rqth7ga3bzhfbrauswfb4xy3mobbelhr6u4aeezpdsiceur6vita

      Leaving blank is something that only works in Desktop.

      Last but not less is checking the doc. Do you have al the prerequisites ok?

      https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops#prerequisites

      I hope that helps,

      • ryszardre's avatar
        ryszardre
        Frequent Visitor
        4 years ago

        My url is:

        Key is much longer than in previous screenshot, similar lenght to your's key. 

        I have "full access" token so I guess it solve all the prerequisites issues.