Hi!
I had recently created a report that pulls information from Azure DevOps. The analytics view is to display Deliverables and Task Groups - All History by Month. This breaks out a table that will select all columns, and list deliverables, task groups, and tasks in one table. I managed to use at left joins to create a hierarchy and merge work item types so that tasks, roll up under task groups, and that task groups roll up to deliverables. It's really neat.
The connection has been running fine every morning as I refresh the report. The other day I refresh the report and nothing changes. The devops reporting normally allows me to audit user mistakes made in tasks tracked. As I audit the tasks, I refresh the report and the changes normally reflect onto the report. Recently, the refresh takes a while and it goes through without errors. The report adds in new lines of data but does not edit tasks that have already been pulled into the report. Is there something I am not doing correctly? I have refreshed query previews... to test, I even created a new power bi, pulled the same data source, and the query shows old data not currently reflected from devops. Has anyone experienced this issue? Any help is appreciated!
