https://community.fabric.microsoft.com/t5/Developer/Building-Data-Model-from-AzureDevOps/m-p/3398299#M44085 <P>Hi Friends,</P><P>&nbsp;</P><P>I am working on some data from AzureDevOps to create a dashboard on workItems. To extract data i am using the API with QueryID and is dynamic. Query is constructed using parameters like Project and WorkItemType etc. This data comes from 2 different sources onPremise(TFS) &amp; Cloud(AzureDevOps).&nbsp; Both these connection uses different authentication with Personal Access Token.</P><P>The challenge i am facing here is integrating both the data into single model so all data can be into one report. I am looking for a suggestion on how this can be acheived and what is the best approach to meet the requirement.</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P> Fri, 25 Aug 2023 04:42:56 GMT manojk_pbi 2023-08-25T04:42:56Z https://community.fabric.microsoft.com/t5/Developer/Building-Data-Model-from-AzureDevOps/m-p/3398299#M44085 <P>Hi Friends,</P><P>&nbsp;</P><P>I am working on some data from AzureDevOps to create a dashboard on workItems. To extract data i am using the API with QueryID and is dynamic. Query is constructed using parameters like Project and WorkItemType etc. This data comes from 2 different sources onPremise(TFS) &amp; Cloud(AzureDevOps).&nbsp; Both these connection uses different authentication with Personal Access Token.</P><P>The challenge i am facing here is integrating both the data into single model so all data can be into one report. I am looking for a suggestion on how this can be acheived and what is the best approach to meet the requirement.</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P> Fri, 25 Aug 2023 04:42:56 GMT https://community.fabric.microsoft.com/t5/Developer/Building-Data-Model-from-AzureDevOps/m-p/3398299#M44085 manojk_pbi 2023-08-25T04:42:56Z