Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Seeking opinions on DevOps datasets feed into Power BI

Hi guru,

I am trying to create a visualisation to provide Power BI (PBI) reporting for an agile run project implementation.

Our company is using Azure DevOps tool to run the agile project and hence, I can connect and extract the dataset from Azure DevOps to feed into my PBI visual reporting. 


My goal is to make this PBI report to be used in any future agile project implementation. However, there is a problem because the next agile tool that the next project going to use might not be AzureDevOps but very likely using JIRA tool.

Both JIRA and AzureDevOps are using the same business logic (i.e. as both are using Agile and Scrum methodology) in their software but the table structure setup (i.e. table name, structure, modelling) will be different among each other.


Hence, the PBI solution which I am going to build which initially to be based on AzureDevOps platform will fail if it is going to be used on JIRA platform in the future.


Questions -

1 - What kind of backend solution is required under such an environment where I am trying to build a PBI solution where it can work successfully in either JIRA or Azure DevOps? 

2 - Should I rebuild another set of similar PBI visualisation solution but cater to the two different tools as they have different datasets?


I am trying to go down to the path of no. 2 because PBI solutions I created for Azure DevOps (i.e. business requirements) will be similar to JIRA (in fact to any agile tool).






Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.