Issue connecting FlowViz (Organization) to our ADO Organization

[frickje]

Issue connecting FlowViz (Organization) to our ADO Organization

[nbrown02]

That looks like it was force closed due to data load, how many projects/work items are in your organisation?

[frickje]

We have 102 in our PRD instance (68 active projects and 34 that we consider in archived state). That makes sense that its a data load issue, we successfully connected it to our Dev instance (12 projects). Is there an option to work around our current issue? If there is an option to multi-select Projects during the load, that would be great! Out of the 68 active projects, we may have approx 50 that would be interested in your metrics.
If not, and I could get our "archived" projects out of there; would 68 be too many?
Really appreciate your help!!

[nbrown02]

It really depends more on the work items, I’m fairly confident 68 would be too many. Unfortunately there is no way to select multiple projects :(Sent from my iPhoneOn 2 Nov 2023, at 13:38, frickje ***@***.***> wrote: We have 102 in our PRD instance (68 active projects and 34 that we consider in archived state). That makes sense that its a data load issue, we successfully connected it to our Dev instance (12 projects). Is there an option to work around our current issue? If there is an option to multi-select Projects during the load, that would be great! Out of the 68 active projects, we may have approx 50 that would be interested in your metrics. If not, and I could get our "archived" projects out of there; would 68 be too many? Really appreciate your help!! —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: ***@***.***>

[frickje]

Bummer to hear. What are your thoughts on us trying to connect to our individual projects using the FlowViz (Project) file, then trying to combine them into one large dataset? Would we be wasting our time? Any other suggestions?

[nbrown02]

There is a way you could do it, but you'd have to change the report and all it's queries to have a filter, something like: https://analytics.dev.azure.com/ORGNAME/_odata/v3.0/WorkItems?%20$filter=%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27APROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27

…

On Thu, Nov 2, 2023 at 3:24 PM frickje ***@***.***> wrote: Bummer to hear. What are your thoughts on us trying to connect to our individual projects using the FlowViz (Project) file, then trying to combine them into one large dataset? Would we be wasting our time? Any other suggestions? — Reply to this email directly, view it on GitHub <#107 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHACM2XCJDZ7ZR7TBNT3YZLYCO3JHAVCNFSM6AAAAAA6Z6LS5SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTOOJQHE2TAMZTHA> . You are receiving this because you commented.Message ID: ***@***.***>

[nbrown02]

Closing issue as due to data volumes being loaded, workaround provided.

[frickje]

CONFIDENTIAL & RESTRICTED Hi Nick, Quick follow up on this. Can you give me a little guidance on how I would update a query? For example, on the Iterations, I see the following (Transform Data, Applied Step - Source): = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/Iterations?%20&$select=ProjectSK,IterationPath,IterationName,IterationSK,StartDate,EndDate,IterationLevel1,IterationLevel2,IterationLevel3,IterationLevel4", null, [Implementation="2.0"]) Am I placing the project names in place of the "Project" parameter? Appreciate the guidance! jessica

________________________________ From: Nick Brown ***@***.***> Sent: Thursday, November 2, 2023 11:06 AM To: nbrown02/FlowViz ***@***.***> Cc: Jessica FOSLIEN ***@***.***>; Author ***@***.***> Subject: Re: [nbrown02/FlowViz] Issue connecting FlowViz (Organization) to our ADO Organization (Issue #107) EXTERNAL Email. Be careful with links and attachments! If in doubt, click the Report Mail button. There is a way you could do it, but you'd have to change the report and all it's queries to have a filter, something like: https://analytics.dev.azure.com/ORGNAME/_odata/v3.0/WorkItems?%20$filter=%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27APROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27

On Thu, Nov 2, 2023 at 3:24 PM frickje ***@***.***> wrote: Bummer to hear. What are your thoughts on us trying to connect to our individual projects using the FlowViz (Project) file, then trying to combine them into one large dataset? Would we be wasting our time? Any other suggestions? — Reply to this email directly, view it on GitHub <#107 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHACM2XCJDZ7ZR7TBNT3YZLYCO3JHAVCNFSM6AAAAAA6Z6LS5SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTOOJQHE2TAMZTHA> . You are receiving this because you commented.Message ID: ***@***.***>

— Reply to this email directly, view it on GitHub<#107 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BDVN2BIEBZIBWNGQH5BMWK3YCPAHFAVCNFSM6AAAAAA6Z6LS5SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTOOJRGAZDOOBXHE>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[nbrown02]

You would need to do something like:

= OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/_odata/v3.0/Iterations?%20$filter=%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20&$select=ProjectSK,IterationPath,IterationName,IterationSK,StartDate,EndDate,IterationLevel1,IterationLevel2,IterationLevel3,IterationLevel4", null, [Implementation="2.0"])

Bold is where you'd need to enter project name, similarly you'd need to take the project parameter out of the query...

[frickje]

CONFIDENTIAL & RESTRICTED Thank you SO much. I'll start working on the updates. I have two successful so far.

…

________________________________ From: Nick Brown ***@***.***> Sent: Wednesday, November 8, 2023 3:36 AM To: nbrown02/FlowViz ***@***.***> Cc: Jessica FOSLIEN ***@***.***>; Author ***@***.***> Subject: Re: [nbrown02/FlowViz] Issue connecting FlowViz (Organization) to our ADO Organization (Issue #107) EXTERNAL Email. Be careful with links and attachments! If in doubt, click the Report Mail button. You would need to do something like: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/_odata/v3.0/Iterations?%20$filter=%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20&$select=ProjectSK,IterationPath,IterationName,IterationSK,StartDate,EndDate,IterationLevel1,IterationLevel2,IterationLevel3,IterationLevel4", null, [Implementation="2.0"]) Bold is where you'd need to enter project name, similarly you'd need to take the project parameter out of the query... — Reply to this email directly, view it on GitHub<#107 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BDVN2BM3MQAON2DDMQVQVDDYDNHC5AVCNFSM6AAAAAA6Z6LS5SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMBRGQYTQOJVG4>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[frickje]

CONFIDENTIAL & RESTRICTED Hi Nick, Are you able to help me with one more? I have the other queries updated, but struggling with the "Teams". Here is the original: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/BoardLocations?%20&$select=TeamSK,ColumnName&$expand=Team($select=TeamName)", null, [Implementation="2.0"]) I tried to update it to: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & "/_odata/v3.0-preview/BoardLocations?$filter=%20Project/ProjectName%20eq%20%27Mobile%27%20or%20Project/ProjectName%20eq%20%27NavIP%27%20&$select=TeamSK,ColumnName&$expand=Team($select=TeamName)", null, [Implementation="2.0"]) but I get the following error: [cid:fb3dfb75-c2ed-49bc-a23c-35de9ee9fb3b] (I am not a developer, if you haven't guessed 🙂) Thanks, Jessica

…

________________________________ From: Nick Brown ***@***.***> Sent: Wednesday, November 8, 2023 3:36 AM To: nbrown02/FlowViz ***@***.***> Cc: Jessica FOSLIEN ***@***.***>; Author ***@***.***> Subject: Re: [nbrown02/FlowViz] Issue connecting FlowViz (Organization) to our ADO Organization (Issue #107) EXTERNAL Email. Be careful with links and attachments! If in doubt, click the Report Mail button. You would need to do something like: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/_odata/v3.0/Iterations?%20$filter=%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20or%20Project/ProjectName%20eq%20%27PROJECTNAME%27%20&$select=ProjectSK,IterationPath,IterationName,IterationSK,StartDate,EndDate,IterationLevel1,IterationLevel2,IterationLevel3,IterationLevel4", null, [Implementation="2.0"]) Bold is where you'd need to enter project name, similarly you'd need to take the project parameter out of the query... — Reply to this email directly, view it on GitHub<#107 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BDVN2BM3MQAON2DDMQVQVDDYDNHC5AVCNFSM6AAAAAA6Z6LS5SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMBRGQYTQOJVG4>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[nbrown02]

Hey Jessica,

So I don't think for that table you would be able to do it - Project isn't an available field for that table.