FlowViz Template Fails to Load ADO Data in Power BI

[NandiiniiRawatt]

Hi, I'm unable to load data from azure devops and keep hitting connectivity errors:

Kindly help!

[nbrown02]

Hey @NandiiniiRawatt - is this quite a large project? I assume it is using the "project" template?

[NandiiniiRawatt]

Hi, It is a large data that I'm fetching from Azure Devops. I'm currently using project template, but struggling with these errors.

[nbrown02]

In that case I'd recommend trying the team template - if there's lots of data/teams in a project this is better to use from a data load/performance perspective.

[NandiiniiRawatt]

With the team template, I'm getting another error regarding data combination. If it has to do with privacy level, since it is a sensitive data, I dont want to change it. How can I resolve that?

[nbrown02]

Hmm that is strange. Can you share the ADO URL for that team and then what you are entering as parameters?

[NandiiniiRawatt]

I refreshed and load the data again, it got resolved. Thanks.
But I have a concern. I want to use multiple teams from a project in the same dashboard. How can I do that? Do you have any alternative?

[nbrown02]

You would have to add a parameter for each team you wanted to load data for and then update each table, for example for WorkItems Completed you would amend it to:

= OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/WorkItems?%20$filter=WorkItemType%20ne%20%27Task%27%20and%20WorkItemType%20ne%20%27Test%20Case%27%20and%20WorkItemType%20ne%20%27Test%20Plan%27%20and%20WorkItemType%20ne%20%27Shared%20Parameter%27%20and%20WorkItemType%20ne%20%27Shared%20Steps%27%20and%20WorkItemType%20ne%20%27Test%20Suite%27%20and%20WorkItemType%20ne%20%27Impediment%27%20and%20StateCategory%20eq%20%27Completed%27%20and%20(Teams/any(x:x/TeamName%20eq%20%27" & #"Team 1" & "%27) or Teams/any(x:x/TeamName%20eq%20%27" & #"Team 2" & "%27) or Teams/any(x:x/TeamName%20eq%20%27" & #"Team 3" & "%27)%20)%20" & "and ChangedDate ge 2024-01-01T00:00:00Z" & "&$select=AreaSK,CompletedDate,CompletedDateSK,CycleTimeDays,LeadTimeDays,ProjectSK,ParentWorkItemID,State,StateCategory,TagNames,Title,WorkItemID,WorkItemType", null, [Implementation="2.0"])

For 3 teams...