Enabling the Analytics View on Azure DevOps for Power BI Connection

Azure DevOps Analytics allows you to connect and get the Azure DevOps Work Items data on Power BI report based on filter criteria provided, very easily. It’s available as a Preview Feature in Azure DevOps. To enable the Analytics view and create custom analytics view, follow the below steps:

1. Click on the User Settings on the top left and click Preview Features.

2. On Preview Feature, Toggle Analytics Views button to ON

2. Once done, you will see Analytics views option enabled in the Left menu of Azure DevOps

3. Click on Analytics View and it will open the Analytics View page. Click New View.

4. In the New View box, provide the Name, Description, Work Items Filters, Fields, History and Click Save.

5. This will make View available, when you will add the Data Source again in your Power BI Desktop.

Summary

Enable Analytics view on Azure DevOps to make it really easy to connect and fetch the data on Power BI to make interactive and rich dashboards.

3 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: