Forum Discussion
Power BI integration help
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 :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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.