Azure TFS Server - Collection

[Anonymous]

Hi,

Is it possible to analyitc in Collection level ? I do nto want join each project in my collections.

Note I also have few collections.

Thanks

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

If you are using Azure DevOps Server Connector, based on this document: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops

For Organization, enter the organization name in Azure DevOps (not the full URL). For example, use fabrikam-fiber-inc if the URL of your organization is "https://dev.azure.com/fabrikam-fiber-inc./".

For Team project, enter just the project name (e.g. use Fabrikam-Fiber if the URL of your project is "https://dev.azure.com/fabrikam-fiber-inc./Fabrikam-Fiber“).

If it doesn't meet your requirement, Could you please provide more details about your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Based on this document, you can omit "/{project}" entirely for a cross-project query.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

If you are using Azure DevOps Server Connector, based on this document: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops

For Organization, enter the organization name in Azure DevOps (not the full URL). For example, use fabrikam-fiber-inc if the URL of your organization is "https://dev.azure.com/fabrikam-fiber-inc./".

For Team project, enter just the project name (e.g. use Fabrikam-Fiber if the URL of your project is "https://dev.azure.com/fabrikam-fiber-inc./Fabrikam-Fiber“).

If it doesn't meet your requirement, Could you please provide more details about your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks on the quick response.

I was referring to Azure DevOps 2019 Server On Premise .

My original requirement was to connect to Collection and to start working on information from the whole collection , I.e. all project under a Collection.

My motivation is to create BI report on all projects under my Collection.

Thanks

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Based on this document, you can omit "/{project}" entirely for a cross-project query.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thanks for the info, Yes It seems the correct solution.

1. Is there any OData queries wizared to simplify creation of OData queries ?

2. I also noticed that I can add project in my View on Azure DevOps.

Thanks

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Sorry for that, we did not found any official wizared tools to simplify creation of OData queries. Here is a quick start about how to connect oData queries: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.