Power BI integration help

[New_worker]

Hey, I am preparing exam and have below question. My answer is A, I think Odata query can access analytic views and filter data. But not sure B. Anyone can help confirm the correct answer? Thanks. 

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 con gure 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?
A. OData queries
B. Azure DevOps (Boards only)
C. Azure DevOps Server (Boards only)
D. OData Feed

[Brianyoung]

If you’re integrating Power BI with external data, make sure to handle incremental loads and error retries. I’ve used Skyvia in setups like that - it takes care of a lot of those pain points.

[Devadarshini_26]

Connect to Power BI Data Connector - Azure DevOps | Microsoft Learn

Option B: Azure DevOps (Boards only)

[Ritaf1983 · Accepted solution]

Hi @New_worker

Your understanding is on the right track, but let's clarify the correct answer by breaking it down:

A. OData queries: OData queries can indeed access Analytics views and allow for filtering data. However, this option is not explicitly listed as a connector in Power BI Desktop, so while it's technically possible, it doesn't meet the requirement of being a direct connector in Power BI Desktop.

B. Azure DevOps (Boards only): This connector allows access to data related to work items in Azure DevOps Boards. However, this connector does not support Analytics views or cloud filtering.

C. Azure DevOps Server (Boards only): This connector is for on-premise data from Azure DevOps Server, not from the cloud, so it wouldn't meet the cloud filtering requirement.

D. OData Feed: This is the correct answer. The OData Feed connector is commonly used in Power BI to access Analytics views from Azure DevOps and allows you to filter the data using OData queries. It aligns with the requirements of using Analytics views and filtering data from the cloud.

Correct answer: D. OData Feed

For more information please refer to the linked article :

https://learn.microsoft.com/en-us/azure/devops/report/powerbi/access-analytics-power-bi?view=azure-d...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[New_worker]

Thank you @Ritaf1983  for the detail explanation.  Really learn more from the sharing.