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

[ryszardre]

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!

[collinq]

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?

[ibarrau]

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]

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]

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#pr...

I hope that helps,

[ryszardre]

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.

[ibarrau · Accepted solution]

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.