Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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