Forum Discussion
Connecting to Azure DevOps via Rest API
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!
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!
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 🙂