Connection to Azure DevOps from Power BI Desktop

0
votes

I'm trying to get a connection from Power BI desktop and my organization's Azure DevOps. URL is currently : https://dev.azure.com/{organization}/{project}

In Power BI, I use the "Azure DevOps Server (Boards only)" type of data connection.

I'm prompted with this :

Power BI connector

After entering "organization" in "collection URL" text box, and "project" in "Team project" text box, I got this error :

Connection Error

Do you have any suggestions? Could it be Firewall?

1
azure-devopspowerbi-desktop
Do you check all prerequisites?? docs.microsoft.com/en-us/azure/devops/report/powerbi/… - msta42a
Hi @David Plante. Could you please check if the answer could solve this issue? If you still have some questions, feel free to let me know. Just a remind of this - Kevin Lu-MSFT

1 Answers

0
votes

From the Organization URL, you are using the Azure Devops Service.

You need to select the Azure Devops (Boards only) option in PowerBI Desktop. This option is for Azure Devops Service.

enter image description here

The Azure Devops Server(Boards Only)option is used for Azure Devops Server instead of Azure Devops Service. I ran into the same issue when I used this option.

Then you could input the organizaiton name in Organization Box and the Project Name in Team Project Box. It can be able to work.