Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector
Get or connect to data
Answer
Correct answer: D — OData Feed is the connector Microsoft documents for consuming Analytics views with cloud-side filtering.
You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps. From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements: • Use Analytics views. • Filter data from the cloud. Which connector should you use?
Community Votes
51% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
Analytics views expose their data as an OData endpoint, and the official walkthrough for consuming them is Get Data > OData Feed with the view's analytics URL — filtering defined in the view is applied in the cloud before data reaches the model.
A bug tracking dashboard must consume Azure DevOps Analytics views from the cloud with server-side filtering, so Power BI Desktop must be pointed at the connector that reads those views directly.
Picking the Azure DevOps (Boards only) connector because it appears in general Azure DevOps reporting docs — that connector builds queries against Boards data directly and is not the path the official Analytics views documentation prescribes; 'OData queries' is not a real Power BI connector name.
Community Discussion (41 comments)
Tex02
👍 23
I think it is B because this link - has this point - Select Get Data > Online Services, Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Then select Connect. Analytics views only support queries against work items and test cases. I am assuming this is about DevOps on the cloud
BIFakeGuru
👍 6
Selected: D
D. OData Feed Azure DevOps Analytics views expose data through OData feeds. Using the OData Feed connector allows Power BI to pull data from Azure DevOps Analytics while leveraging its built-in filtering capabilities. Why not the other options? A. OData Queries: While this is a generic term, Power BI uses the "OData Feed" connector to interact with OData sources. B. Azure DevOps (Boards only): This connector is designed specifically for Azure Boards data but doesn't support Analytics views or advanced filtering. C. Azure DevOps Server (Boards only): This connector is for on-premises Azure DevOps Server and not the cloud version.
b92fc92
👍 1
Selected: B
B in my opinion
b92fc92
👍 1
Selected: B
B in my opinion
naretkhu
👍 1
Selected: B
Analytics views only support Azure Boards data : https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
tecnoyescas
👍 1
Selected: B
The answer is B. In the microsoft documentations is explained. https://learn.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report?view=azure-devops
Pitxunet
👍 1
Selected: A
So I checked the Microsoft documentation again. They specifically recommend OData queries to load the Analytics data into Power BI out of the three available methods (OData Query, OData Feed, Azure DevOps). You can find the information here: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops
NadeemSalam
👍 2
Selected: D
The OData Feed connector allows you to connect to cloud-based Azure DevOps services and apply filters directly in Power Query to retrieve only the required data.
Pitxunet
👍 1
Selected: B
It's not OData Feed because it is not a good option to filter the data, which is one of the requirements in the question. I found this on the Learn Microsoft site: The method demonstrated in this article works for small organizations, because it always pulls in all the data into Power BI. Most of the filtering that's specified in the Power Query Editor is done client-side. For information about other approaches, see Power BI integration Overview.
Pitxunet
👍 2
Selected: B
It is B. This is the learn.microsoft documentation about it: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report? view=azure-devops Connect to an Analytics view 4.Select Get Data > Online Services, then select Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Select Connect. Analytics views only support queries against work items and test cases.
Fatima300
👍 1
Selected: A
OData queries allow Power BI to connect to Analytics views in Azure DevOps and filter data from the cloud. OData Feed is another term used for the OData connector that can pull data from cloud services, including Azure DevOps Analytics. but requires manual setup compared to OData queries here Options B and C are for Boards only, which does not meet the requirement for using Analytics views. Option D is more general and less specific to Azure DevOps Analytics.
jtm2001
👍 1
Selected: B
the example used in this learn article is exactly the same as the question. https://learn.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report?view=azure-devops check below a section from the article on learn : With Power BI Desktop, you can easily connect to an Analytics view to start creating reports for your project in Azure DevOps. An Analytics view provides a simplified way to specify the filter criteria for a Power BI report based on Analytics data. Important Analytics views only support Azure Boards data (work items).
Onketsu
👍 1
Selected: B
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
MANANDAVEY
👍 4
Selected: D
To create a bug tracking dashboard in Power BI that pulls data from Analytics in Azure DevOps, you should use the OData Feed connector. Here's why: Use Analytics Views: Analytics in Azure DevOps provides data through OData endpoints. The OData Feed connector allows Power BI to access these endpoints and utilize Analytics views. Filter Data from the Cloud: The OData Feed connector supports querying and filtering data directly from the cloud source, reducing the amount of data imported into Power BI.
f133b89
👍 3
Selected: D
Use Analytics Views: Analytics views in Azure DevOps are exposed via OData, which allows querying data from the cloud using structured formats. The OData Feed connector in Power BI is designed to connect to OData endpoints, such as Azure DevOps Analytics views. Filter Data from the Cloud: The OData Feed connector allows you to apply filters and queries to fetch only the required data from Azure DevOps in the cloud.
leela1507
👍 4
Selected: B
To meet the requirements of using Analytics views and filtering data from the cloud, you should use the Azure DevOps (Boards only) connector. This connector is specifically designed to work with Analytics views in Azure DevOps and supports cloud-based data filtering (https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops).
Arnav123
👍 1
Selected: A
A over D because it is odata querie is more streamilned and efficent
mdnaseershah
👍 1
Selected: B
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
2de72fd
👍 1
Selected: D
While B seem to be the correct option, the question says you need to authenticate for the Azure service. That step is done in Odata feed. Option B has analytics view but you do not authenticate for the Azure service (the step doesnt exist). Ref: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops. Therefore the answer should be D.
Ajr01
👍 2
Selected: A
To authenticate to Azure DevOps, use the OData queries connector in Power BI Desktop, as it supports accessing and filtering Analytics views from the cloud.
raavan108
👍 2
Selected: D
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops
et_phone_home_777
👍 1
Selected: B
B - See https://learn.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report?view=azure-devops
Rio98
👍 2
Selected: D
OData Feed is the connector designed for retrieving data from OData services, which Azure DevOps provides for Analytics views
Rio98
👍 3
Selected: D
A. OData queries: This is a method for querying OData but not the actual connector you need to use in Power BI. B. Azure DevOps (Boards only): This connector is specifically for Boards (work items) and does not support Analytics views or advanced filtering. C. Azure DevOps Server (Boards only): This is for on-premises Azure DevOps Server, not the cloud version, which you are using. So the answer is D
Jaitin
👍 3
Selected: D
The correct answer is: D. OData Feed Why Not the Other Options?: A. OData Queries: While related, this is not a specific connector option in Power BI Desktop. B. Azure DevOps (Boards only): This connector is limited to Azure Boards and does not integrate with Analytics Views. C. Azure DevOps Server (Boards only): This is for on-premises Azure DevOps Server, not Azure DevOps Services (cloud).
Mo_Suhail
👍 1
Selected: D
OData Feed allows you to connect directly to Azure DevOps Analytics views, which are accessible via the OData protocol. Analytics Views in Azure DevOps are specifically designed to simplify querying and visualizing data from Azure DevOps services, and OData Feed is the connector that supports accessing these views. Filtering data from the cloud is supported by OData feeds, as you can apply filters within the OData query before importing the data into Power BI.
huoyq163
👍 1
Selected: D
I think D, https://learn.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops
jaume
👍 2
In the link shared by f3ecb98 below, I understand to connect to Azure DevOps data an OData connector is needed. I've checked in Power BI Desktop available "OData connector" is presented as "ODat Feed" (once connected, an OData code must be written to set the OData queries retrieving data, but these are not connectors) so I would vote for Answer D
Layla0322
👍 3
Selected: D
A. OData queries: While this refers to querying OData, Power BI does not have a specific connector called "OData queries." Instead, it uses the OData Feed connector. B. Azure DevOps (Boards only): This connector is used for Board-related data but does not support Analytics views or OData.
ASC88
👍 1
Selected: D
We need a connector, ODATA is the only one that is a connector.
f3ecb98
👍 3
Selected: D
This is explained in https://learn.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops, there is no such thing as an OData query connector, it is called an OData Feed connector in Power BI.
3433bf6
👍 2
Selected: A
OData Queries, refer to the document. https://learn.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops ----> "All filtering is done server-side." <------- Power BI can execute OData queries. OData queries are powerful and can filter and aggregate data before returning it to Power BI
LuluSkyy
👍 4
Chat GPT says the correct answer is D - OData feed as its the correct connector to use Analytical views and filter data from the cloud.
Davery
👍 2
Selected: A
OData Queries so that it has the ability to filter
f07fa5c
👍 1
Selected: B
Belive its B
Davery
👍 1
Selected: A
Copilot says it is A Azure DevOps (Boards only), is designed specifically for connecting to Azure DevOps Boards. While it can be useful for accessing work items and board-related data, it does not support Analytics views or filtering data from the cloud as required for your bug tracking dashboard. For your needs, OData queries remain the best choice because they allow you to leverage Analytics views and filter data directly from the cloud.
Ganga425
👍 1
Selected: B
I think B To connect Power BI Desktop to Azure DevOps for creating a bug tracking dashboard, you should use the Azure DevOps (Boards only) data connector. Here are the steps to configure it: Open Power BI Desktop. Sign in to the service. First-time access requires you to sign in and authenticate your credentials. Go to Get Data > Online Services. Select Azure DevOps (Boards only) for cloud services or Azure DevOps Server (Boards only) for on-premises1. Connect and specify the necessary parameters, such as the Collection URL and Team Project name
MonikaStop
👍 1
Selected: B
B is the right answer
rab21
👍 2
Selected: B
B is the right answer
9d92039
👍 1
Selected: A
Using OData, you can directly query Analytics for Azure DevOps from a supported browser. Use the returned JSON data as you like. Enterprise organizations can generate queries that span multiple projects or an entire organization or project collection.
Jayaruwan
👍 3
Selected: A
OData queries It can filter data
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Analytics views expose data through OData feeds, and Microsoft's documentation for accessing Analytics data with Power BI explicitly instructs you to use the OData feed connector in Power BI Desktop, pasting the view's analytics endpoint URL. Because the view itself performs the filtering server-side, data is filtered from the cloud before it is loaded into the model, exactly as the requirement states. The OData Feed connector (D) is the only listed option that consumes those views in this prescribed way.Why the Other Options Are Wrong
OData queries (A) is not the name of any Power BI connector, so it is a distractor built to look plausible. Azure DevOps (Boards only) (B) is a real connector designed for querying Boards work item data directly; it does not consume user-defined Analytics views and is aimed at the scenario where you build the query inside Power BI rather than use a pre-filtered view. Azure DevOps Server (Boards only) (C) targets an on-premises deployment, which contradicts the requirement to filter data from the cloud.Community Comment Notes
The most-endorsed comment defends option B by quoting the Azure DevOps connector documentation for cloud services, but that page describes connecting directly to Boards data, not to Analytics views. Another highly voted comment explains that Analytics views expose data through OData feeds, which is the reasoning behind D and matches the official Analytics views walkthrough.Official Reference
Frequently Asked Questions
Why is OData Feed correct for Azure DevOps Analytics views in Power BI?
Analytics views expose data as OData feeds, so the OData Feed connector (D) reads the view URL and filters server-side before import into Power BI.
Can I use Azure DevOps (Boards only) instead of OData Feed for Analytics views?
No. Azure DevOps (Boards only) (B) queries Boards work items directly and does not consume user-defined Analytics views, so it fails the scenario.
Is OData queries (A) a valid Power BI connector for Azure DevOps Analytics?
No. OData queries (A) is not a real connector; OData Feed (D) is the connector documented for Analytics view endpoints.
Related Analysis
Practice All PL-300 Questions
Access 116 questions with complete answers and detailed explanations.
View Full PL-300 Practice Test →