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 entering username

 

I use Odata connector and this solution works in Power BI Desktop.

 

Thanks for all your help!

 

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. 

6 Replies

  • 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.

  • collinq's avatar
    collinq
    Super User
    4 years ago

    Hi ryszardre ,

     

    I believe that the answer given by ibarrau is correct and should answer the question you asked.  But, I am wondering you don't just use the Azure Dev Ops connector?  Does that not provide you with what you need?