Building Data Model - from AzureDevOps

[manojk_pbi]

Hi Friends,

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) & Cloud(AzureDevOps).  Both these connection uses different authentication with Personal Access Token.

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.

Thanks