Question 412016 in Azure Question posted in
The official documentation to get you started can be found here.

Copying Azure devops boards Analytic view to Microsoft fabrics lakehouse

I’m trying to copy Azure DevOps board’s Analytic shared view data into Fabric Lakehouse.

It is a custom view created using Workitem fields and have shared view setting (All users on your project can see this view and use it in Power BI).

myProject/Boards/Analytics views –> New View

I tried using oData connector, https://analytics.dev.azure.com/{OrganizationName}/{ProjectName}/_odata/v3.0-preview

with this I can access Workitems, WorkitemSnapshot, WorkItemRevision, Area, Iteration etc. but I couldn’t access the custom/shared view I created.

Anyone knows how to do this?

Able to copy/access Analytics View/Shared view data into Microsoft fabrics Lakehouse

Tags:

2

Answers


  1. 0

    You might want to check the API wit/queries as mentioned in the link -https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/queries/get?view=azure-devops-rest-7.1&tabs=HTTP

    or https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.1&tabs=HTTP where in you can pass the query, which can be your view as well.

    Login or Signup to reply.
  2. 0

    I am afraid that the Custom/Shared views in Azure DevOps Analytic views can not be used in Fabric Lakehouse.

    Refer to this doc: About Analytics views

    An Analytics view provides a simplified way to specify the filter criteria for a Power BI report based on Analytics data.

    Currently, Analytics views can only be directly used in Power BI. We are not able to use it in Fabric Lakehouse.

    To get the work items data in Fabric Lakehouse, we need to use Odata Query.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search