Connecting to Azure DevOps via Rest API

[StephenRabobank]

Hello,

ref: Fetching Test Plans and Linked Test Cases from Azure DevOps to Power BI | Microsoft Community Hub

I am trying to understand how to implement this solution. I have a personal access token from Azure DevOps to use, but I do not see anywhere in the web connector to put the Personal Access Token.

I was thinking there would be an Authorization or something in this section where I would put the PAT against.

There isn't an ODATA or other source (that i've found) to be able to pull this from Azure DevOps, so if someone knows that, it would be good. But this is Power BI so, I'm just looking for a general answer 🙂

Thanks

[SamWiseOwl · Accepted solution]

Hi @StephenRabobank 

First check in your Data Source Settings both Current file and Global I have been tripped up before by Power BI saving a previous attempt.

Then I wonder if it is a similer issue I had, any time I tried to hide the token it wouldn't let me enter it here:

Instead I have to pass it in using M, I wrote a step by step here:
https://www.wiseowl.co.uk/power-bi/blogs/power-bi-desktop/data-sources/using-api-key/

Drove me absolutely crazy. 
Another type I ran into was using a Cookie and passing that as a URL parameter header:
https://www.wiseowl.co.uk/power-bi/blogs/power-bi-desktop/data-sources/cookie-api-authentication/

Hope one of these puts you on the right track!

[StephenRabobank]

Thanks for the help.

I now know how to do this, at issue is there appears to be some sort of enhanced security in place that prevents not only the PAT but using my Azure AD credentials to get to the Rest APIs through Power BI. Although doing it from a web browser works fine.....gotta love security sometimes 🙂